从
ch_info_commission_req_detail表中随机抽取50%的记录
方法一:
select * from ch_info_commission_req_detail sample(50) where region is not null;
方法二(一般使用这种方法):
select *
from ch_info_commission_req_detail
where rownum <= (select count(*) from ch_info_commission_req_detail) * 0.5
order by dbms_random.value;