ODBiC Discussion Board


RE: Need syntax for ORDER BY (a date), charlee, 10-16-2002

RE: Need syntax for ORDER BY (a date)

by Louis van Eijk
October 20, 2002 14:11

Are you sure that the whole syntax is correct.

If you just use the column_name after ORDER BY it should work.

When you want to sort the ORDER BY just TYPE DESC after the COLUMN_NAME.

SELECT * FROM inv ORDER BY date DESC;

Louis


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 


Copyright ©1997, Roger Harris. All rights reserved.