获得具有行限制子句的前 N 行
FETCH
子句是在 Oracle 12c R1 中引入的:
SELECT val
FROM mytable
ORDER BY val DESC
FETCH FIRST 5 ROWS ONLY;
没有 FETCH 的示例也适用于早期版本:
SELECT * FROM (
SELECT val
FROM mytable
ORDER BY val DESC
) WHERE ROWNUM <= 5;
FETCH
子句是在 Oracle 12c R1 中引入的:
SELECT val
FROM mytable
ORDER BY val DESC
FETCH FIRST 5 ROWS ONLY;
没有 FETCH 的示例也适用于早期版本:
SELECT * FROM (
SELECT val
FROM mytable
ORDER BY val DESC
) WHERE ROWNUM <= 5;