I need to build a view on this data and select only the latest rows that have run last at the same time runtime. I would NOT know the run when I run the statement. In the above, the result should have rows from no=15 thru no=10 (runtime 12:20:10).
I suppose I could do the following way:
select * from X
where runtime=(select runtime from X where rownum<2 order by runtime desc);
Any suggestion please.
08-29-2002, 06:01 PM
select * from x where runtime=
(select max(runtime) from x);