On Fri, Jan 13, 2012 at 9:10 AM, Igor Tandetnik <[email protected]> wrote:
> Dilip Ranganathan <[email protected]> wrote: > > Suppose among emp1 and emp2, I only want to see the entry with the latest > > timestamp. > > select timestamp, value, person from mytable t1 > where rowid = ( > select rowid from mytable t2 where t1.person=t2.person > order by value desc, timestamp desc limit 1); > > Igor Thank you very very much. That worked like a charm. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
