日期:2014-05-16  浏览次数:20410 次

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;