查询随机的十条记录
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
查询随机的十条记录
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