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.