-- Oracle 分页 -- 20 = (currentPage-1) * pageSize + pageSize 每页显示几条 -- 10 = (currentPage-1) * pageSize 当前页数 SELECT * FROM (SELECT o.*, ROWNUM rn FROM tb_phone o WHERE ROWNUM <=20 AND o.model LIKE ?) WHERE rn>10
本文共 274 字，大约阅读时间需要 1 分钟。
-- Oracle 分页 -- 20 = (currentPage-1) * pageSize + pageSize 每页显示几条 -- 10 = (currentPage-1) * pageSize 当前页数 SELECT * FROM (SELECT o.*, ROWNUM rn FROM tb_phone o WHERE ROWNUM <=20 AND o.model LIKE ?) WHERE rn>10
转载于:https://my.oschina.net/zhuyongfei/blog/130258