max and associated value

[skhanal]

Can post more detail. You can do something like

select * from table
where time=
select max(time) from table