Oracle中分页语句的写法

select empno,ename,r from 
   (select empno,ename,rownum r from emp)
where r<11 and r>4


select empno,ename,r from 
   (select empno,ename,rownum r from emp where rownum<11)
where r>4

  

原文地址:https://www.cnblogs.com/danawill/p/7436363.html