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" <dixo...@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.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...@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode