select * from (
select * from t
where rownum < trunc(dbms_random.value(2,1000))
order by dbms_random.value
)
where rownum=1
Oracle 百万数据随机取一条性能优化
最新推荐文章于 2021-09-20 10:18:19 发布
select * from (
select * from t
where rownum < trunc(dbms_random.value(2,1000))
order by dbms_random.value
)
where rownum=1