oracle分頁(yè)查詢(xún)語(yǔ)句 oracle為什么做個(gè)分頁(yè)關(guān)鍵字？
oracle為什么做個(gè)分頁(yè)關(guān)鍵字？分頁(yè)的宗旨是控制查詢(xún)出來(lái)的數(shù)據(jù)個(gè)數(shù)，下面這條語(yǔ)句對(duì)于Oracle分頁(yè)已經(jīng)足夠了。（注：該語(yǔ)句只能用于Oracle）SELECT * FROM (SELECT temp
oracle為什么做個(gè)分頁(yè)關(guān)鍵字？
分頁(yè)的宗旨是控制查詢(xún)出來(lái)的數(shù)據(jù)個(gè)數(shù)，下面這條語(yǔ)句對(duì)于Oracle分頁(yè)已經(jīng)足夠了。
（注：該語(yǔ)句只能用于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