SqlServer-MySql-Oracle随机查询语句

SQL Server：
    Select TOP N * From TABLE order By NewID()

Access：
    sql = "select top N * from table order by rnd(" & r & "-id)"
    rnd(" & r & "-id) 其中的id是自动编号字段，可以利用其他任何数值来完成，比如用姓名字段(UserName)
    select top 10 * from table order by rnd(" & r & "-Len(UserName))
    注：Id:为你当前表的唯一ID字段名
   
MySql：
    Select * From TABLE order By Rand() Limit N
   
ORACLE：
    select * from (select * from table order by dbms_random.value) where rownum<10
   
DB2:
    SELECT column, RAND() as IDX
    FROM table
    ORDER BY IDX FETCH FIRST 1 ROWS ONLY