SQL SERVER中有两个随机函数：newID()和RAND()
其中newID()是生成一个36位的Grid码，而RAND()函数则是生成一个小数，如果要取100以内的整数，可用floor(rand()*100) 获得。
--随机排序说明,在表tblTopic中随机排序
SELECT * FROM tblTopic order by newid()
--取前十条
SELECT top 10 * FROM tblTopic order by newid()
MsSql随机取数据 select top 10 * from tblTopic order by newid() Access 随机取数据 SELECT top 10 id FROM tblTopic order by rand(id) mySql 随机取数据 SELECT id FROM tblTopic order by rand() limit 10