日期:2014-05-16 浏览次数:20541 次
mysql:select * from tablename order by rand() limit 10
sqlserver:select top 10 * from tablename order by newid()
oracle:使用 dbms random value的一种方法
sql> select *from (select *from t order by dbms_random.value) where rownum<10;