Select * from (Select tab1.*,rownum rn from
(select * from employees where first_name like 'D%' order by salary desc)
tab1 where rownum<=5) tab2 where rn>=3;
Select * from (Select tab1.*,rownum rn from
(select * from employees where first_name like 'D%' order by salary desc)
tab1 where rownum<=5) tab2 where rn>=3;