This query produces the expected result, which is the records in
descending time order:

SELECT RXSTAMP FROM RXOLDREQUESTRECORDS ORDER BY RXSTAMP DESC

this one doesn't, the records are in ascending order:

SELECT RXSTAMP FROM RXOLDREQUESTRECORDS ORDER BY 1 DESC

(RXSTAMP is a TIMESTAMP)

Can anyone suggest why? A similar query I have contains a union so
using the first form is not possible...

Thanks,


Martin