Oracle 分组排序

row_number() over(partition by col1 order by col2)

根据col1分组，根据col2排序，连续唯一排序

select a.*,row_number() over(partition by rgon_id order by app_id) mm from ecp_std_code a;

 

rank() over(partition by col1 order by col2)

根据col1分组，根据col2排序，跳跃排序

select a.*,rank() over(partition by rgon_id order by app_id) mm from ecp_std_code a;

 

dense_rank() over(partition by col1 order by col2)

根据col1分组，根据col2排序，连续不唯一排序

select a.*,dense_rank() over(partition by rgon_id order by app_id) mm from ecp_std_code a;