日期:2014-05-16 浏览次数:20468 次
select * from (select * from table order by dbms_random.value ) where rownum < 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;