MYSQL: select * from tablename order by rand() limit 10
sqlserver: select top 10 * from tablename order by NEWID()
random抽取n个记录的SQL(mysql和sqlserver),SQL的随机数
最新推荐文章于 2022-01-03 14:15:42 发布
MYSQL: select * from tablename order by rand() limit 10
sqlserver: select top 10 * from tablename order by NEWID()