oracle分页

select * from (
select nsr.*,ROWNUM row_id from (select * from hx_dj.dj_nsrxx order by djxh) nsr where ROWNUM <= 60
) where row_id >= 29

有时候子查询里面的order by 条件会导致查出来的结果顺序错乱。

转载于:https://www.cnblogs.com/shenzhichipingguo/p/8989796.html