oracle分页排序查询方法

admin

select * from (select ROWNUM r, s.* from LJBUSAMOUNT s WHERE ROWNUM <=10) where r>= 1
select * from (select ROWNUM r, s.* from LJBUSAMOUNT s WHERE ROWNUM <= 20) where r>=11
select * from (select ROWNUM r, s.* from LJBUSAMOUNT s WHERE ROWNUM <= 30) where r>=21


总行数 = select  count(*) from LJBUSAMOUNT
总页数=总行数/每页数量
如果有小数则
总页数=到整数（总页数）
总页数=总页数+1

admin

select * from (

select rownum RN,count(1) over(partition by 1) total, a.* from LJACCOUNT a
where accountid = '80110047'

) b where RN <20 and RN >0