Oracle分页查询

1.select * from (

select A.*,ROWNUM  RN

from (select * from table_car)A

where ROWNUM<=40

)

where RN>=20;

大多数情况下，效率较高

2.select * from(

select A.*,ROWNUM RN(select * from table_car)A

)

where RN between 20 and 40;

第二种，查询效率较第一种低