what about this one:
SELECT * FROM intern_copy ORDER BY true DESC LIMIT 10
--
viro
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
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 2
omy-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 10 records from a table ?
From: roger.e.
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 descending, and still SELECT TOP 10.
On S
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 ?
>
>
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 ?
>
>
gt; > 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, 2015 8:59 AM, "John Dixon" <dixo...@hotmai
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 mailing list
use-livecode@lists.runrev.com
Please visit
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, 2015