select * from (
select a.*,rownum rn from (
select c1,c2,count(*) over() total from table where ....
) a where rownum <= 结束条数
) where rn >= 开始条数
oracle 分页的另一种写法,将总条数作为列返回
最新推荐文章于 2024-04-30 16:44:46 发布
select * from (
select a.*,rownum rn from (
select c1,c2,count(*) over() total from table where ....
) a where rownum <= 结束条数
) where rn >= 开始条数