mybitis分页模板(Oracle)

mybitis分页模板(Oracle)

SELECT *
  FROM (SELECT TMP.*, ROWNUM ROW_ID
          FROM (sql语句) TMP
         WHERE ROWNUM <= 10)
 WHERE ROW_ID > 0

例如

SELECT *
  FROM (SELECT TMP.*, ROWNUM ROW_ID
          FROM (SELECT A.ID "id", A.NAME "name"
                  FROM ROOT.STUDENT A
                 WHERE '1' = '1') TMP
         WHERE ROWNUM <= 10)
 WHERE ROW_ID > 0