Access:
select top n * from table order by rnd(id)'id为数据库的自动编号字段
Sql Server:
select top n * from table order by newid()
转至刘军的blog
http://blog.csdn.net/liujun999999/archive/2004/11/11/177657.aspx
Access:
select top n * from table order by rnd(id)'id为数据库的自动编号字段
Sql Server:
select top n * from table order by newid()
转至刘军的blog
http://blog.csdn.net/liujun999999/archive/2004/11/11/177657.aspx