如何从一个表中随机地取出20 条不重复的数据? 主键是Id


随机取出n条记录:

Sql server:select top n * from 表 order by newid()

Access:Select top n * FROM 表 orDER BY Rnd(id)

mysql:Select * From 表 order By rand() Limit n
原文地址:https://www.cnblogs.com/Fooo/p/782616.html