從表中隨機返回n條記錄，返回n記錄

從表中隨機返回n條記錄，返回n記錄

創建測試用表：

CREATE OR REPLACE VIEW V AS
SELECT 'a' AS c FROM dual
UNION ALL
SELECT 'b' AS c FROM dual
UNION ALL
SELECT 'c' AS c FROM dual
UNION ALL
SELECT 'd' AS c FROM dual
UNION ALL
SELECT 'e' AS c FROM dual;
SELECT * FROM v;

查詢語句如下：

SELECT c
  FROM (SELECT c FROM v ORDER BY DBMS_RANDOM.VALUE())
 WHERE ROWNUM < 3;

查詢結果如下：