导读：mysql:select*fromtablenameorderbyrand()limit10 sqlserver:selecttop10*fromtablenameorderbyNEWID()
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()
更多文章请关注《万象专栏》
转载请注明出处：https://www.wanxiangsucai.com/read/cv132879
话题推荐： #取随机记录的语句#