几种数据库随机函数小结

1、SqlServer中随机提取数据库记录
 
select top n * from 表 order by newid()
--------------------------------------------------------------------------------
select top 10 * from tablename order by NEWID()   

select top 10 * from tablename order by NEWID()

2、mysql中随机提取数据库记录  
Select * From 表 order By rand() Limit n
-------------------------------------------------------------------------------
select * from tablename order by rand() limit 10

select * from tablename order by rand() limit 10

 
3、Access中随机提取数据库记录
Select top n * FROM 表 orDER BY Rnd(id)
-------------------------------------------------------------------------------
SELECT top 10 * FROM tablename ORDER BY Rnd(FId)   
SELECT top 10 * FROM tablename ORDER BY Rnd(FId)

FId:为你当前表的ID字段名

4、Oracle中随机提取数据库记录

 select * from (select * from tablename order by dbms_random.random) where rownum<6;