mysql中随机取10条数据
select * from 表名 order by rand() limit 10
oracle中随机取1条数据
select * from(select * from 表名 order by dbms_random.value)
select * from 表名 order by rand() limit 10
oracle中随机取1条数据
select * from(select * from 表名 order by dbms_random.value)