On Fri, Jan 13, 2012 at 9:10 AM, Igor Tandetnik <itandet...@mvps.org> wrote:
> Dilip Ranganathan <misc.us...@gmail.com> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users