Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Possible Use of a Cursor
Not sure if this is exactly it, but it should be easy enough to tweak:
select * from (
select first_value(machine_proc) over (partition by instruction_nr
order by position_nr) first_machine_proc
from tab)
where first_machine_proc in (3600, 3400, 3430)
Received on Tue Feb 22 2005 - 17:22:34 CST