oracle

查询随机的十条记录

select * from (select * from tb_option order by dbms_random.random) where rownum<=10;

其他的数据库

SQL Server:

SELECT TOP 10 * FROM T_USER ORDER BY NEWID() MySQL: SELECT * FROM T_USER ORDER BY RAND() LIMIT 10