RE: order by rrn, or lifo?

["Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx>]

Tim,

Try adding ORDER BY RRN(your file name here) DESC.

HTH,

Rick

-----Original Message-----
From: Hatzenbeler, Tim [mailto:thatzenbeler@xxxxxxxxxxxxx]
Sent: Wednesday, August 06, 2003 2:58 PM
To: 'Midrange Systems Technical Discussion'
Subject: order by rrn, or lifo?

Is it possible on a sql select statement, to order my results by the latest
record in the file to the oldest?  without using a date field?  I would like
to order by the rrn, highest to lowest...

thanks, tim

This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.