SQL> select * from (select ename,job from emp order by dbms_random.value() ) where rownum <5
2 ;
ENAME JOB
---------- ---------
WARD SALESMAN
JAMES CLERK
BLAKE MANAGER
KING PRESIDENT
SQL> /
ENAME JOB
---------- ---------
TURNER SALESMAN
CLARK MANAGER
SMITH CLERK
WARD SALESMAN
SQL> /
ENAME JOB
---------- ---------
SCOTT ANALYST
KING PRESIDENT
SMITH CLERK
CLARK MANAGER
SQL> /
ENAME JOB
---------- ---------
SCOTT ANALYST
JAMES CLERK
JONES MANAGER
SMITH CLERK
random随机函数
最新推荐文章于 2022-07-19 21:00:00 发布
这篇博客展示了如何在SQL查询中利用dbms_random.value函数进行随机抽样,通过示例演示了如何获取表emp中随机的前5条记录。
摘要由CSDN通过智能技术生成