select * from (select p.*,row_number() over (order by p.passvehicleid desc ) rk from passvehicleinfo p) where rk>9980 and rk<10000
或者。。 select * from (select view1.*,rownum rn from (select p.* from passvehicleinfo p order by p.passvehicleid desc) view1 where rownum<10000) view2 where rn>9980小于最大的,大于最小的,就是你需要的条数
pageNum代表当前页,pageSize代表每页记录条数 select a.a from ( select a,a.row_ ( select a,rownum row_ from t_a ) a where a.row_<=pageNum*pageSize ) a where a.row_>(pageNum-1)*pageSize
select * from (select view1.*,rownum rn from (select p.* from passvehicleinfo p order by p.passvehicleid desc) view1 where rownum<10000) view2 where rn>9980小于最大的,大于最小的,就是你需要的条数
select a.a
from (
select a,a.row_
(
select a,rownum row_ from t_a
) a
where a.row_<=pageNum*pageSize
) a
where a.row_>(pageNum-1)*pageSize