SQL按随机读取数据的语句MsSql、Access、mySql
阅读:4405 输入:2014-12-17 12:31:12
如何用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