--smaple(xxx) xxx是百分比,5代表5%
--随机抽取记录
select * from tm_sd_usrinfo1 sample(5) where rownum < 10 ;
--这样可以保证产生的随机数在0---1000之间!
select * from (select * from t order by trunc(dbms_random.value(0,1000)))
where rownum<50;
--smaple(xxx) xxx是百分比,5代表5%
--随机抽取记录
select * from tm_sd_usrinfo1 sample(5) where rownum < 10 ;
--这样可以保证产生的随机数在0---1000之间!
select * from (select * from t order by trunc(dbms_random.value(0,1000)))
where rownum<50;