faqts : Computers : Programming : Languages : Asp : ASP/VBScript : Common Problems : Database and SQL

+ Search
 Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

33 of 45 people (73%) answered Yes
Recently 8 of 10 people (80%) answered Yes

Entry

What is the exact syntax of the SQL 'ORDER BY' CLAUSE if I want the order to be in descending order?

May 31st, 2000 07:17
unknown unknown, Jason Peak
 


If your using MS SQL Server, the syntax would be

"SELECT *
FROM Winners
ORDER BY Points DESC"



© 1999-2004 Synop Pty Ltd