The 'fetch first row only' clause is your friend. If you want the last,
then 'order by ______ desc' where the _____ is the sequence defining what
is the last record.
You can use a subselect for simplicity, or the lateral join if you need to
use the results of this select in the larger query.
From: Alan Shore <ashore@xxxxxxxx>
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
Date: 06/15/2016 12:27 PM
Subject: Obtaining the "last" record in a group via SQL
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
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.
midrange.com
