drop table t ;
create table T AS SELECT LEVEL L,SYS_GUID() S FROM DUAL CONNECT BY LEVEL <= 100 ORDER BY 2;
select * from (select * from t sample(50) order by trunc(dbms_random.value(0, 1000))) where rownum <= 10 order by 1;
ORACLE单表随机获取N条记录
最新推荐文章于 2023-07-18 10:54:12 发布