方法1:
select gmsfhm, xm
from ( select gmsfhm, xm from czrk where gmsfhm like '%%' order by dbms_random.value )
where rownum <= 100
方法2:
select gmsfhm, xm
from ( select gmsfhm, xm from czrk where gmsfhm like '%%' order by dbms_random.random )
where rownum <= 100;
方法3:(速度会快点)
select gmsfhm,xm
from ( select gmsfhm, xm from czrk sample(1) where gmsfhm like '%%' order by dbms_random.random )
where rownum <= 100;