比如要取id>100的十条记录,取多次,要求每次取得的都不一样,怎么写SQL语句?
---------------------------------------------------------------
Sql server :
select top 10 * from 表 order by newid();
Access:
select top 10 * from 表 order by rnd(id)
比如要取id>100的十条记录,取多次,要求每次取得的都不一样,怎么写SQL语句?
---------------------------------------------------------------
Sql server :
select top 10 * from 表 order by newid();
Access:
select top 10 * from 表 order by rnd(id)