Mr. Puneet Kishor <punk.k...@gmail.com> wrote: > CREATE TABLE uris ( > uri_id INTEGER PRIMARY KEY, > uri TEXT > ); > > > CREATE TABLE history ( > history_id INTEGER PRIMARY KEY, > uri_id INTEGER, > downloaded_on DATETIME DEFAULT CURRENT_TIMESTAMP > ); > > I am looking for an efficient way to select the uris, and the latest > 'downloaded_on' time stamp for each uri, but am drawing a > blank.
select uris.uri_id, uris.uri, max(downloaded_on) from uris join history using (uri_id) group by uris.uri_id; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
