从Access，Sql Server，MySQL，Oracle数据库里随机读取几条数据方法 

Access:
s*elect top n * from table order by rnd(id)‘id为数据库的自动编号字段

Sql Server:
s*elect top n * from table order by newid()

MySQL:

S*ELECT * FROM table order by rand() limit  20; 

Oracle:

s*elect * from table order by dbms_random.＆#118alue()

asp 调用Accessrnd(id)数据一样:

asp中用调用access 数据库时用RUN每次都一样的话应该在调用前添加Randomize用 rnd(-(id+"& rnd() &"))调用

Randomize

s*elect top n * from table order by  rnd(-(id+"& rnd() &"))‘id为数据库的自动编号字段