oracle 分页查询

SELECT * FROM ( SELECT temp.*, ROWNUM AS RN FROM (select name from test) temp WHERE ROWNUM <= ? * 10 ) WHERE RN > (? - 1 ) * 10

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/chigd/p/9764904.html