取随机记录的语句
(编辑：jimmy 日期: 2024/11/24 浏览：3 次 )
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()
下一篇：海量数据库的查询优化及分页算法方案集合2/2