从表中随机返回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;
查询结果如下:
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。