<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[hzivan的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/hzivan</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; hzivan]]></copyright><item><title><![CDATA[SQL随机提取N条记录]]></title><link>https://blog.youkuaiyun.com/hzivan/article/details/447840</link><guid>https://blog.youkuaiyun.com/hzivan/article/details/447840</guid><author>hzivan</author><pubDate>Sun, 07 Aug 2005 20:30:00 +0800</pubDate><description><![CDATA[随机提取10条记录的例子： Sql server： select top 10 * from 表 order by newid() Access： SELECT top 10 * FROM 表 ORDER BY Rnd(id) Rnd(id) 其中的id是自动编号字段，可以利用其他任何数值来完成 比如用姓名字段(UserName) SELECT top 10 * FROM 表 ORDER BY R]]></description><category></category></item></channel></rss>