取随机记录的语句
程序员文章站
2022-04-16 12:00:55
mysql: select * from tablename order by rand() ...
mysql: select * from tablename order by rand() limit 10
sqlserver: select top 10 * from tablename order by newid()
sqlserver: select top 10 * from tablename order by newid()