order by dbms_random.value(1,50),再嵌套一层rownum
select *
from (select rownum, empno
from (select empno from emp order by dbms_random.value(1, 50)))
where rownum <= 3;
测试结果：
SQL> select *
2 from (select rownum, empno
3 from (select empno from emp order by dbms_random.value(1, 50)))
4 where rownum <= 3;
ROWNUM EMPNO
---------- -----
1 7654
2 7902
3 7499
SQL>
SQL> select *
2 from (select rownum, empno
3 from (select empno from emp order by dbms_random.value(1, 50)))
4 where rownum <= 3;
ROWNUM EMPNO
---------- -----
1 7902
2 7900
3 7654
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31402276/viewspace-2128618/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
查询一张表的索引数
请登录后发表评论
登录
全部评论
