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