Hi,
This is the query which will give top 3rd and 4th value.
select *
from(select * from Your_table order by somecoloum desc)
where rownum<5
Minus
select *
from( select * from Your_table order by somecoloum desc)
where rownum<3 ;

Bye
Sheetal