摘要： 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 阅读全文