sql 随机取数

Sql server:
      select top 10 * from 表 order by newid()
Access:
      SELECT top 10 * FROM 表 ORDER BY Rnd(id)
MySql:
     Select * From 表 Order By rand() Limit 10

原文地址:https://www.cnblogs.com/ldms/p/3525376.html