0

I need to order these dates in descending order (last should be first) and in fact how they now appear. However they do not necessarily appear like those so I need a SQL Order By clause to order these descending:

2012-01-23 09:53:24.097105

2012-01-20 17:31:57.565458

2012-01-20 17:01:09.154587

2012-01-20 16:28:40.685735

2012-01-16 12:03:54.99954

Here is my SQL (which returns an error):

SELECT
    TransmissionSend.CreateTimestamp
FROM
    Interface_SFAX.TransmissionSendItem
ORDER BY TransmissionSend.CreateTimestamp DESC

I need help creating a working SQL query that displays the times in descending order... Any help would be great!

Thanks!!

Edited by PhilEaton

2
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by JorgeM
1

Your SQL statement above shows you selecting from a different table than your ORDER BY field.

TransmissionSend vs TransmissionSendItem.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.