随机取出n条记录:
Sql server:select top n * from 表 order by newid()
Access:Select top n * FROM 表 orDER BY Rnd(id)
mysql:Select * From 表 order By rand() Limit n
This entry was posted
on 星期六, 04月 21st, 2007 at 11:06 am and is filed under 数据库|SQLServer.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.