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;
oracle 分页查询
原文：https://www.cnblogs.com/wupf/p/9019250.html
