最高效率的ORACLE分页:
SELECT * FROM
(SELECT ROWNUM AS ROWNO,t.* FROM table t WHERE t.STATUS=1 AND ROWNUM <= 13) ub
WHERE UB.ROWNO >=0;
转载于:https://my.oschina.net/u/2336787/blog/528082
最高效率的ORACLE分页:
SELECT * FROM
(SELECT ROWNUM AS ROWNO,t.* FROM table t WHERE t.STATUS=1 AND ROWNUM <= 13) ub
WHERE UB.ROWNO >=0;
转载于:https://my.oschina.net/u/2336787/blog/528082