On Fri, Jan 13, 2012 at 9:10 AM, Igor Tandetnik wrote:
> Dilip Ranganathan 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 = (
>
Dilip Ranganathan 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
2 matches
Mail list logo