oracle 分页的原理
select ename,sal from
(select ename ,sal ,rownum r from
(select ename,sal from emp order by sal desc)
where rownum <=10)
where r>5 ;
mysql分页
select ename ,sal from emp order by sal desc limit n,m;
表示从索引值为n开始取(实际是从第n+1条记录开始取) 取m个
select ename,sal from
(select ename ,sal ,rownum r from
(select ename,sal from emp order by sal desc)
where rownum <=10)
where r>5 ;
mysql分页
select ename ,sal from emp order by sal desc limit n,m;
表示从索引值为n开始取(实际是从第n+1条记录开始取) 取m个