站长资源数据库
取随机记录的语句
简介mysql: select * from tablename order by rand() limit 10 sqlserver: select top 10 * from tablename order by NEWID()
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()