随机抽取表中数据

方法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;