1ãOracleæ¥è¯¢ç»æéï¼éæºæåº
select * from tableName order by dbms_random.value();2ãMySQLéæºæ¥è¯¢ï¼éæºæåº
SELECT * FROM tableName ORDER BY rand()3ãSQLéæºæ¥è¯¢ï¼éæºæåº
SELECT * FROM tableName ORDER BY NEWID()4ãOracleéæºæ¥è¯¢20æ¡
select * from5ãMy SQLéæºæ¥è¯¢20æ¡
select * from tableName order by rand() limit 206ãMS SQL Serveréæºæ¥è¯¢20æ¡
select top 20 * from tableName order by newid()