Re: [sqlite] selecting unique list of latest timestamps

Mr. Puneet Kishor 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

[sqlite] selecting unique list of latest timestamps

I have a bunch of uris stored in a table CREATE TABLE uris ( uri_id INTEGER PRIMARY KEY, uri TEXT ); uri_id uri -- -- 1 http://foo.com 2