oracle随机取数据,通过随机函数包dbms_random,按随机排序实现,如下
随机取几条记录
--方法一
select * from (select * from t_sms_game_down t order by dbms_random.value) where rownum <5;
--方法二
select * from (select * from t_sms_game_down t order by sys_guid()) where rownum <5;
select trunc(dbms_random.value(100,200)) from dual; --生成100和200之间的随机数,trunc取整