[thelist] SQL: Reverse ORDER BY?

[Nicole Parrot]

SELECT #fieldlist#
FROM EmailData
ORDER BY DateSent DESC

Nicole

----- Original Message ----- 
From: "Frank" <framar at interlog.com>
To: <thelist at lists.evolt.org>
Sent: Friday, March 30, 2001 1:19 PM
Subject: [thelist] SQL: Reverse ORDER BY?


> 
> What is the syntax for creating a reverse sort in SQL?
> 
> SELECT #fieldlist#
> FROM EmailData
> ORDER BY DateSent
> 
> So to show the latest at the top of a sort, what would I say?
> -- 
> 
> "Fate is just the weight of circumstances."
> 
> Frank Marion                      Loofah Communications
> frank at loofahcom.com               http://www.loofahcom.com
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 
>