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效率最高