取随机记录的语句
发布时间:2016-12-28 来源:查字典编辑
摘要:mysql:select*fromtablenameorderbyrand()limit10sqlserver:selecttop10*fr...
mysql:select*fromtablenameorderbyrand()limit10
sqlserver:selecttop10*fromtablenameorderbyNEWID()
mysql:select*fromtablenameorderbyrand()limit10
sqlserver:selecttop10*fromtablenameorderbyNEWID()