On Sep 5, 2012, at 3:03 PM, Richard Hipp <d...@sqlite.org> wrote: > SELECT id, a, b, ..., min(mtime) > FROM tab > GROUP BY id > ORDER BY min(mtime) DESC;
Perhaps something along these lines, i.e. a simple self-join: select foo.* from foo join ( select id, min( mtime ) as mtime from foo group by id ) as MinFoo on MinFoo.id = foo.id and MinFoo.mtime = foo.mtime order by foo.mtime desc _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users