1 select * from (select rownum rn, d.* from DJDRIVER d )p where <=20 and >=10;
2 select * from (select rownum rn, d.* from DJDRIVER d )p where between 10 and 20;
3 select * from (select rownum rn, d.* from DJDRIVER d where rownum<=20 )p where >=10;
测试发现1和2方式效率低,方式3效率最高