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

[Roger Eller]

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" <dixonja at hotmail.co.uk> wrote:

> 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.eller at sealedair.com
> > To: use-livecode at lists.runrev.com
> >
> > Sort descending, and still SELECT TOP 10.
> > On Sep 20, 2015 8:59 AM, "John Dixon" <dixonja at hotmail.co.uk> 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 mailing list
> > > use-livecode at lists.runrev.com
> > > Please visit this url to subscribe, unsubscribe and manage your
> > > subscription preferences:
> > > http://lists.runrev.com/mailman/listinfo/use-livecode
> > >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>