oracle 11g 分页
替换sql种的limit
SELECT * FROM ( select ROWNUM AS RN,a.* from CONFIG_INFO a WHERE ROWNUM<=10)WHERE rn>5;
版权声明:本文为chuang777原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。
oracle 11g 分页
替换sql种的limit
SELECT * FROM ( select ROWNUM AS RN,a.* from CONFIG_INFO a WHERE ROWNUM<=10)WHERE rn>5;