select * from
(select t.*,rownum rn from
(select * from 表名 [条件]) t where rownum <= 页数*条数)
where rn > (页数-1) * 条数;
分页查询公式
最新推荐文章于 2022-09-09 20:22:44 发布
select * from
(select t.*,rownum rn from
(select * from 表名 [条件]) t where rownum <= 页数*条数)
where rn > (页数-1) * 条数;