高效oracle分页

  SELECT * FROM (SELECT ROWNUM AS ROWNO,t.* FROM INFO_USER_BASIC t WHERE t.STATUS=1 AND ROWNUM <= 13) ub  WHERE UB.ROWNO >=0; 

编程技巧