RE: SQL question: return the last record of groups

That is correct.  If REUSEDLT is set to *YES, you will need some type of data 
field such as tracking number or timestamp to get the last record.  The idea is 
that you can order by desc and the first record of the resultset would be the 
last record  that got added to the file.


-----Original Message-----
From: midrange-l-bounces+lim.hock-chai=usamobility.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+lim.hock-chai=usamobility.com@xxxxxxxxxxxx]On
Behalf Of Vernon Hamberg
Sent: Friday, June 10, 2005 7:44 AM
To: Midrange Systems Technical Discussion
Subject: RE: SQL question: return the last record of groups


This is not reliable when REUSEDLT is *YES.

Vern

At 04:08 PM 6/9/2005, you wrote:

>there is probably an easier way to do this.  But some far this is what I 
>come up with:
>order by rrn(myFile) desc
>
>-----Original Message-----
>From: midrange-l-bounces@xxxxxxxxxxxx
>[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Reggie Acosta
>Sent: Thursday, June 09, 2005 3:59 PM
>To: midrange-l@xxxxxxxxxxxx
>Subject: SQL question: return the last record of groups
>
>
>Would it be possible to form an SQL incantation that will return the last
>record of the group of records for an entity? For example, I need to access
>info that I'd normally get from the sales order header file. But, alas, some
>orders have been completed and purged. Fortunately we have a sales order
>header audit trail file. The last record for an order in the audit trail
>would have the info needed. I'd need to get the last audit trail records for
>all the purged sales orders. I beg the master SQL wizards, please share your
>wisdom. :)
>
>TIA,
>Reggie Acosta
>Brown Jordan International
>www.brownjordan.com
>
>
>--
>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.
>
>
>--
>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.