Re: Is there something like FETCH FIRST 3 ROWS ONLY but I need FETCH LAST ROW

[a4g atl <a4ginatl2@xxxxxxxxx>]

I do not need to get the date and time back. I need the truck number from
the last delivery.

Darryl

On Mon, Oct 9, 2017 at 4:49 PM, Alan Shore <ashore@xxxxxxxx> wrote:

> Hi Darryl
> Need some things clarified
> Why is MAX not a solution in this case - especially when you then say
> The test is on the max of date and time, (2 fields).
>
> What is the LAST record - the last record entered based upon the max date
> and time?
>
> You will need to combine BOTH of these fields and create a timestamp -
> that way you will need to get the record with the latest timestamp
>
>
>
> 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
> a4g atl
> Sent: Monday, October 09, 2017 4:44 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Is there something like FETCH FIRST 3 ROWS ONLY but I need FETCH
> LAST ROW
>
> I am using a SELECT to retrieve a value from a table. For some records,
> there are more than 1 results.
>
> Is it possible to do a SELECT to get the last occurrence of a value
> without need to define dynamic SQL and read all records until I get the
> last record?
>
> Using MAX is not a solution in this case.
>
> The test is on the max of date and time, (2 fields).
>
> This is a V7.1 system.
>
> TIA
>
> Darryl Freinkel.
> --
> 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: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD
>
> --
> 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: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD