oracle為什么做個分頁關(guān)鍵字？分頁的宗旨是控制查詢出來的數(shù)據(jù)個數(shù)，下面這條語句對于Oracle分頁已經(jīng)足夠了。（注：該語句只能用于Oracle）SELECT * FROM (SELECT temp

oracle為什么做個分頁關(guān)鍵字？

分頁的宗旨是控制查詢出來的數(shù)據(jù)個數(shù)，下面這條語句對于Oracle分頁已經(jīng)足夠了。

（注：該語句只能用于Oracle）

SELECT * FROM (SELECT temp.*， ROWNUM RN FROM (SELECT * FROM USERS ORDER BY ID DESC) temp) WHERE RN > 0 AND RN <= 10

SELECT *

FROM (SELECT AA.*， ROWNUM RN

FROM (SELECT * FROM USERS ORDER BY ID DESC) AA)

WHERE RN > 0 AND RN <= 10