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;
第二种,查询效率较第一种低
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;
第二种,查询效率较第一种低