Re: can this be done more elegant?

another way of doing this would be:

select time,event_type,speed
from
(
select time,event_type,speed

      ,dense_rank() over (order by time desc) r   from test_ride
 where event_type = 'curve_R'
)
where r=1

br,
stephan Received on Wed Apr 19 2006 - 12:26:43 CDT