Re: [sqlite] Finding rows with MIN(MTIME) for all IDs

[Baruch Burstein]

     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 <d...@sqlite.org> 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ʎ ɟı
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users