select t.*,row_number() over(partition by PROJ_ID order by SHOP_CODE) row_number from CQ_CIVIL_WORK_SHOP t
这里是对shop_code进行排序 , 并且以proj_id进行分组
select t.*,row_number() over(partition by PROJ_ID order by SHOP_CODE) row_number from CQ_CIVIL_WORK_SHOP t
这里是对shop_code进行排序 , 并且以proj_id进行分组