标题: ORACLE 3种方式的分页查询SQL [打印本页] 作者: 何小豆儿在此 时间: 2024-11-14 12:38 标题: ORACLE 3种方式的分页查询SQL 1 select * from (select rownum rn, d.* from DJDRIVER d )p where p.rn<=20 and p.rn>=10;
2 select * from (select rownum rn, d.* from DJDRIVER d )p where p.rn between 10 and 20;
3 select * from (select rownum rn, d.* from DJDRIVER d where rownum<=20 )p where p.rn>=10;
测试发现1和2方式服从低,方式3服从最高