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博客 ” ,链接:http://blog.itpub.net/31402276/viewspace-2128618/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31402276/viewspace-2128618/