oracle 分页查询 

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

 

posted @ 2018-10-10 10:27  helloworId  阅读(114)  评论(0)  编辑  收藏  举报