MERGE INTO t_com a USING ( SELECT t_group, t_code, t_name , ROW_NUMBER() OVER(PARTITION BY t_group ORDER BY t_code) t_order FROM t_com ) b ON (a.t_group = b.t_group AND a.t_code = b.t_code) WHEN MATCHED THEN UPDATE SET t_order = b.t_order WHEN NOT MATCHED THEN INSERT VALUES(b.t_group, b.t_code, b.t_name, b.t_order ;질문하실때 예시자료를 확실히 해주시면 멀리 돌아가지 않고 바로 답이 나올 수도 있었겠네요.