Whats the benefit of getting a sorted query and then sorting that query again?
On Tue, Jul 12, 2016 at 12:45 AM, Stephen Chrzanowski <pontia...@gmail.com> wrote: > Simons + My answer; > > select * from (SELECT date_time_stamp FROM general ORDER BY date_time_stamp > DESC LIMIT 2) a order by date_time_stamp; > > On Mon, Jul 11, 2016 at 7:33 PM, Simon Slavin <slav...@bigfraud.org> > wrote: > > > > > On 12 Jul 2016, at 12:25am, Keith Christian <keith1christ...@gmail.com> > > wrote: > > > > > A table has a column of dates and times that look like this: > > > > > > 2015-10-02 07:55:02 > > > 2015-10-02 07:55:02 > > > 2015-10-02 10:00:03 > > > 2015-10-02 10:05:02 > > > 2015-10-02 10:10:02 > > > > > > > > > Schema: > > > CREATE TABLE general ( id integer primary key autoincrement, server > > > text, date_time_stamp text); > > > > > > > > > Would like to get the latest two dates and times, kept in ascending > > > order, e.g. the query should return these two values: > > > > > > 2015-10-02 10:05:02 > > > 2015-10-02 10:10:02 > > > > SELECT date_time_stamp FROM general ORDER BY date_time_stamp DESC LIMIT 2 > > > > The only difference is that the rows will always be in the reverse order > > to what you asked for: biggest timestamp first. But since it's > consistent > > that shouldn't be a problem. > > > > I recommend you create an index on the date_time_stamp column, since that > > will make the above query work far faster. > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
