select * from (select * from ur_table order by sys_guid()) where rownum<n;或者 select * from (select * from ur_table order by dbms_random.value) where rownum<n; sys_guid(),dbms_random.value都是系统函数!这个语句可以随机抽取
select dbms_random.random from dualselect dbms_random.value from dual都可以生成随机数的,
select trunc(dbms_random.value(1,300)) from tm_fasvk1~300之间的随机整数
select * from (select * from ur_table order by dbms_random.value) where rownum<n;
sys_guid(),dbms_random.value都是系统函数!这个语句可以随机抽取