ORACLE单表随机获取N条记录
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))) ...
原创
2019-11-18 17:38:11 ·
265 阅读 ·
0 评论