Sort descending, and still SELECT TOP 10.
On Sep 20, 2015 8:59 AM, "John Dixon" wrote:
> I understand how to select, say the top 10 records in a table... What
> would the best way to select the last 10 records from a table ?
>
> ___
> use-livecode maili
Thanks.. :-) I'll try that ...
> Date: Sun, 20 Sep 2015 09:27:44 -0400
> Subject: Re: SQL Select... the last 10 records from a table ?
> From: roger.e.el...@sealedair.com
> To: use-livecode@lists.runrev.com
>
> Sort descending, and still SELECT TOP 10.
> On Sep 20,
My SQL buddy also adds, "It all depends on what the SELECT is being
ORDER'ed BY; typically a date time stamp.".
On Sep 20, 2015 9:39 AM, "John Dixon" wrote:
> Thanks.. :-) I'll try that ...
>
> > Date: Sun, 20 Sep 2015 09:27:44 -0400
> > Subje
Inverse sort, limit 10
Bob S
> On Sep 20, 2015, at 05:59 , John Dixon wrote:
>
> I understand how to select, say the top 10 records in a table... What would
> the best way to select the last 10 records from a table ?
>
> ___
tp://livecodebeginner.economy-x-talk.com
Op 9/20/2015 om 15:39 schreef John Dixon:
Thanks.. :-) I'll try that ...
Date: Sun, 20 Sep 2015 09:27:44 -0400
Subject: Re: SQL Select... the last 10 records from a table ?
From: roger.e.el...@sealedair.com
To: use-livecode@lists.runrev.com
Sort descen
--
Mark Schonewille
http://economy-x-talk.com
Buy the most extensive book on the
LiveCode language:
http://livecodebeginner.economy-x-talk.com
Op 9/20/2015 om 15:39 schreef John Dixon:
Thanks.. :-) I'll try that ...
Date: Sun, 20 Sep 2015 09:27:44 -0400
Subject: Re: SQL Select... the last
thanks Bob ... :-)
> From: bobsnei...@iotecdigital.com
> To: use-livecode@lists.runrev.com
> Subject: Re: SQL Select... the last 10 records from a table ?
> Date: Mon, 21 Sep 2015 15:42:05 +
>
> Inverse sort, limit 10
>
> Bob S
>
>
> > On Sep 20