RE: Obtaining the "last" record in a group via SQL

I want to thank everyone that responded with their suggestions
I ended up writing a program as the logic became a little more involved

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Wednesday, June 15, 2016 12:38 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Obtaining the "last" record in a group via SQL

Depends on the order number. Is it a sequential number so that the most current order number is always going to be the highest?

If yes, then

Order By OrderNumber Desc

If no, can be anything, do you have a timestamp or something that says when the order was created?

If yes, then

Order By CeateTimestamp Desc

The trick is how do you know what the last record in the group is?



On Wed, Jun 15, 2016 at 9:27 AM, Alan Shore <ashore@xxxxxxxx> wrote:

Hi everyone
Before I forget - we are on V5r4 - soon to upgrade (to at least V7r1 -
yaaaaaay)

Here is my question
II am looking at 2 files
The first file contains 2 fields
Customer number
Data from the last order placed by that customer number So for this
first file - customer number is unique

A logical (by customer number) of orders placed So for the second file
- there can be 1 to many records per customer number

My question is :-
Is there an "EASY" way via sql to get the LAST record for the
individual customer number Please note that "EASY" is stressed, upper
case, underlined , bold

I will probably need to create a program - but just wondered if anyone
had any procedures/proceses/tricks to get that last record from a
group

As always - all answers welcome with gratitude Alan Shore E-mail :
ASHORE@xxxxxxxx Phone [O] : (631) 200-5019 Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
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.

Please contact support@xxxxxxxxxxxx for any subscription related questions.