随机提取N条记录
随机提取10条记录的例子： <BR><STRONG>Sql server：</STRONG> <br><br>select top 10 * from 表 order by newid() <br><br><STRONG>Access：</STRONG> <br><br>SELECT top 10 * FROM 表 ORDER BY Rnd(id) <br><br>Rnd(id) 其中的id是自动编号字段，可以利用其他任何数值来完成 <br><br>比如用姓名字段(UserName) <br><br>SELECT top 10 * FROM 表 ORDER BY Rnd(len(UserName)) <br><br><STRONG>MySql：</STRONG> <br><br>Select * From 表 Order By rand() Limit 10
頁:
[1]