--按3条分一页,查询出第2页
select * from (select u.*,rownum rn from tab_user u where rownum<=2*3) where rn>(2-1)*3
rownum <= (2(页数)*3(条数)) rn > ((2(页数)-1)页数-1)*3(条数)
转载于:https://www.cnblogs.com/meishibiexuejava/p/8537717.html
--按3条分一页,查询出第2页
select * from (select u.*,rownum rn from tab_user u where rownum<=2*3) where rn>(2-1)*3
rownum <= (2(页数)*3(条数)) rn > ((2(页数)-1)页数-1)*3(条数)
转载于:https://www.cnblogs.com/meishibiexuejava/p/8537717.html