作者:antefigure850_495 | 来源:互联网 | 2017-05-12 16:09
Access:selecttopn*fromtableorderbyrnd(id)id为数据库的自动编号字段SqlServer:selecttopn*fromtableorderbynewid()
Access:
select top n * from table order by rnd(id)'id为数据库的自动编号字段
Sql Server:
select top n * from table order by newid()