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