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
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