mysql中取随机n条记录

发布时间:2006-10-19 22:27:33来源:红联作者:ckernel

取随机n条记录
mysql: select * from tablename order by rand() limit 10
sqlserver: select top 10 * from tablename order by NEWID()