天天看點

[資料庫彙總]-- 資料庫實作随機查詢

oracle
select * from t_user order by dbms_random.value;
mysql
select * from t_user order by rand() limit 20;
sql Server
select  top 20   * from  表名  order by  newid();