怎么用SQL语句取出随机的记录?

比如要取id>100的十条记录,取多次,要求每次取得的都不一样,怎么写SQL语句?
---------------------------------------------------------------

Sql server :
select top 10 * from 表 order by newid();
Access:
select top 10 * from 表 order by rnd(id)

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus