mysql: select * from tablename order by rand() limit 10
sqlserver: select top 10 * from tablename order by NEWID()
随机抽取n个记录的SQL（mysql和sqlserver）
简介：mysql: select * from tablename order by rand() limit 10
sqlserver: select top 10 * from tablename order by NEWID()
责任编辑：admin