RE: order by rrn, or lifo?

["Metz, Zak" <Zak_Metz@xxxxxx>]

Assuming RRN indicates the latest inserted...Sure!

select rrn(myfile),whatever
from myfile
order by rrn(myfile) desc

> -----Original Message-----
> From: Hatzenbeler, Tim [mailto:thatzenbeler@xxxxxxxxxxxxx]
> Sent: Wednesday, August 06, 2003 3: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...
NOTICE: This E-mail may contain confidential information. If you are not
the addressee or the intended recipient please do not read this E-mail
and please immediately delete this e-mail message and any attachments
from your workstation or network mail system. If you are the addressee
or the intended recipient and you save or print a copy of this E-mail,
please place it in an appropriate file, depending on whether
confidential information is contained in the message.