SQL Select... the last 10 records from a table ?

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:

RE: SQL Select... the last 10 records from a table ?

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

Re: SQL Select... the last 10 records from a table ?

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.

Re: SQL Select... the last 10 records from a table ?

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

Re: SQL Select... the last 10 records from a table ?

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 ? > >

Re: SQL 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 ? > >

RE: SQL 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

SQL Select... the last 10 records from a table ?

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

RE: SQL Select... the last 10 records from a table ?

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