我这个效率很低,,,有没有快点的办法保证每次取出的随机一行
表数据量很大
SELECT * FROM (SELECT * FROM TableA ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM <= 1;
select
------解决方案--------------------
select * from t_source sample(1) where rownum = 1;