select * from (select rownum r,s.* from book s where rownum <=4) where r>=2;
select * from (select rownum r,s.* from book s) where r between 2 and 3;
Oracle分页查询的两种方法
最新推荐文章于 2024-04-06 22:51:49 发布
select * from (select rownum r,s.* from book s where rownum <=4) where r>=2;
select * from (select rownum r,s.* from book s) where r between 2 and 3;