SQL隨機查詢語句
方法如下
SQL Server
Select TOP N * From TABLE order By NewID()
Access
dim r
randomize
r = rnd
sql = "select top
rnd(" & r & "
select top
MySql
Select * From TABLE order By Rand() Limit
orACLE
select *from (select *from t order by dbms_random
From:http://tw.wingwit.com/Article/program/MySQL/201311/29531.html