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;

 

 

posted @ 2018-05-10 13:44  wupf  阅读(93)  评论(0编辑  收藏  举报