今天遇到这个需求,但是网上只有MySQL的实现,然后自己仿造MySQL语法写出来Oracle的实现方式。
select *
from (select rank() over(partition by [字段名] order by dbms_random.value) row_num,
b.*
from [表名] b)
where row_num<= [每组随机数量];
今天遇到这个需求,但是网上只有MySQL的实现,然后自己仿造MySQL语法写出来Oracle的实现方式。
select *
from (select rank() over(partition by [字段名] order by dbms_random.value) row_num,
b.*
from [表名] b)
where row_num<= [每组随机数量];