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

[Alan Campin <alan0307d@xxxxxxxxx>]

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.