你的位置:首页 > 数据库

[数据库]从表中随机返回n条记录


创建测试用表:

CREATE OR REPLACE VIEW V ASSELECT 'a' AS c FROM dualUNION ALLSELECT 'b' AS c FROM dualUNION ALLSELECT 'c' AS c FROM dualUNION ALLSELECT 'd' AS c FROM dualUNION ALLSELECT 'e' AS c FROM dual;SELECT * FROM v;

查询语句如下:

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

查询结果如下: