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
Oracle中分页语句的写法
原文:http://www.cnblogs.com/danawill/p/7436363.html