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

  

posted @ 2017-08-26 21:01  danawill  阅读(386)  评论(0编辑  收藏  举报