Sorry, that won't work. On Wed, Sep 5, 2012 at 4:12 PM, Baruch Burstein <[email protected]>wrote:
> SELECT id, a, b, ..., mtime > FROM tab > WHERE rowid IN ( > SELECT id, min(mtime) > > FROM tab > GROUP BY id > ) > ORDER BY mtime DESC; > > > On Wed, Sep 5, 2012 at 4:03 PM, Richard Hipp <[email protected]> wrote: > >> >> SELECT id, a, b, ..., min(mtime) >> FROM tab >> GROUP BY id >> ORDER BY min(mtime) DESC; > > > > > -- > ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > > -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
