SQL按随机读取数据的语句MsSql、Access、mySql

| | 2012/05/11 14:14 , mdy
Mysql , 评论(0) , 阅读(1726) , Via 本站原创
Tags: ,
如何用SQL读取随机数据

MsSql随机取数据 select top 10 * from TableName order by newid()
Access 随机取数据 select  SELECT top 10 id FROM 表1 order by rnd(id)
mySql 随机取数据 SELECT id FROM gueze order by rand() limit 10