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