Sql server:
select top 10 * from 表 order by newid()
Access:
SELECT top 10 * FROM 表 ORDER BY Rnd(id)
MySql:
Select * From 表 Order By rand() Limit 10
Sql server:
select top 10 * from 表 order by newid()
Access:
SELECT top 10 * FROM 表 ORDER BY Rnd(id)
MySql:
Select * From 表 Order By rand() Limit 10