oracle取分组的前N条数据
时间:2022-03-14 04:27
select * from
(
select animal,age,id,
row_number()over(partition by animal order by age desc) row_num
from zoo
)
where row_num <=5;
时间:2022-03-14 04:27
select * from
(
select animal,age,id,
row_number()over(partition by animal order by age desc) row_num
from zoo
)
where row_num <=5;