本文共 1285 字，大约阅读时间需要 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_name
WHERE conditions
ORDER BY column_name
OFFSET (page - 1) * pageSize ROWS
FETCH 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_name
WHERE conditions
ORDER BY column_name
OFFSET (page - 1) * pageSize ROWS
FETCH NEXT pageSize ROWS ONLY

??

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

转载地址：http://mlpfk.baihongyu.com/