Use DESC...
SELECT FIELD1
FROM TABLENAME
ORDER BY FIELD1 DESC
Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (561) 423-2674
http://www.hallofsports.com
.. . . where the legends live on
> -----Original Message-----
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 1:33 PM
> To: CF-Talk
> Subject: Order By
>
>
> How can I display an output in reverse order by?
> I want only the last record to be displayed.
>
> Thansk for your help,
> Rich
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
