---------------------------随机取一条数据------------------------------------------
select message_name from (select rownum rr,message.* from message)
where rr= (select trunc(dbms_random.value(1,(select count(*) from message)+1)) from dual)
------------------随机排序然后取一条数据-------------------------------------------------------
select a.*,rownum from(select m.* from message m order by dbms_random.random)a where rownum=1
随机数据库查询
最新推荐文章于 2024-08-06 19:19:19 发布