SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM <= 100) WHERE RN >= 76
本文共 156 字,大约阅读时间需要 1 分钟。
SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM <= 100) WHERE RN >= 76
转载于:https://my.oschina.net/u/1015065/blog/125631