17,377
社区成员
发帖
与我相关
我的任务
分享
with a as
(select 1 id, 10 pri from dual
union all
select 1 id, 101 pri from dual
union all
select 2 id, 12 pri from dual
union all
select 2 id, 14 pri from dual
union all
select 2 id, 18 pri from dual
)select row_number() over (partition by id order by pri) num, id, pri from a;