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