作者:骆锐锋1_665 | 来源:互联网 | 2018-04-20 07:46
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()