本文共 1263 字，大约阅读时间需要 4 分钟。

Oracle ????

Oracle ???????????????????????????????????????????????

?????? ROWNUM

ROWNUM ? Oracle ???????????????????????????????????????????

SELECT * FROM (    SELECT ROWNUM r, t.*    FROM (        SELECT column1, column2, ...         FROM table_name        WHERE conditions        ORDER BY column_name    ) t    WHERE ROWNUM <= (page * pageSize)    AND r >= ((page - 1) * pageSize + 1)

?????? FETCH FIRST ? OFFSET?Oracle 12c?

? Oracle 12c ???FETCH FIRST ? OFFSET ????????? SQL ???????????????

SELECT column1, column2, ...FROM table_nameWHERE conditionsORDER BY column_nameOFFSET (page - 1) * pageSize ROWSFETCH FIRST pageSize ROWS ONLY

?????? ROW_NUMBER()

ROW_NUMBER() ????????????????????????????????????????

SELECT * FROM (    SELECT ROW_NUMBER() OVER(ORDER BY column_name) AS rn, t.*    FROM table_name    WHERE conditions) WHERE rn BETWEEN ((page - 1) * pageSize + 1) AND (page * pageSize)

?????? OFFSET ? FETCH NEXT?Oracle 12c?

?? FETCH FIRST ? OFFSET?Oracle 12c ??? FETCH NEXT ????????????

SELECT column1, column2, ...FROM table_nameWHERE conditionsORDER BY column_nameOFFSET (page - 1) * pageSize ROWSFETCH NEXT pageSize ROWS ONLY

??

???????? Oracle ??????????????????????????????????? ROWNUM?FETCH FIRST ? OFFSET??? ROW_NUMBER() ?????????????????????????