oracle随机取n条记录
oracle随机取n条记录
select * from (select * from table order by dbms_random.value ) where rownum < n
oracle 分段取n条随机记录
select * from (select * from (select a1.*,rownum rn from (select * from table) a1 where rownum<=4) where rn>=2 order by dbms_random.value ) where rownum < 2;