«
»
随机选取数据库中的N条记录
Posted @ 3:54 pm November 8th, 2006

select top 10 * from tablename order by NEWID() --这个是SQL Server的用法

select * from tablename order by rand() limit 10 --这个是mysql的用法

This entry was posted on Wednesday, November 8th, 2006 at 3:54 pm and is filed under 工作备忘, 软件网络. 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.

«
»
Leave a Reply