绝地无双
1、Oracle查询结果集,随机排序1select * from tableName order by dbms_random.value();2、MySQL随机查询,随机排序1SELECT * FROM tableName ORDER BY rand()3、SQL随机查询,随机排序1SELECT * FROM tableName ORDER BY NEWID()4、Oracle随机查询20条12345select * from( select * from tableName order by dbms_random.value) where rownum <= 20;5、My SQL随机查询20条1select * from tableName order by rand() limit 206、MS SQL Server随机查询20条1select top 20 * from tableName order by newid()