随机取数据库中的记录

 随机取数据库中的记录
(1) ACCESS:
      SELECT TOP n * FROM [tablename] {WHRER condition} ORDER BY RND(field_name) {ASC/DESC}

(2) SQL SERVER:
      SELECT TOP n * FROM [tablename] {WHRER condition} ORDER BY NEWID() {ASC/DESC}

(3) MYSQL:
      SELECT * FROM [tablename] ORDER BY RAND() {ASC/DESC} LIMIT n

(4) ORACLE:
      SELECT * FROM (SELECT * FROM [tablename] ORDER BY DBMS_RANDOM.VALUE) temp WHERE rownum <= n

      select * from (select * from [tablename] order by dbms_random.value(min,max)) where rownum<=n