oracle 分页查询

select *
from (select rownum as rr,t.* from (select * from emp where sal is not null order by sal)t
where rownum <=10
)where rr>2;