[postgreSQL] 중복된 로우 삭제

DELETE FROM 테이블명
WHERE 컬럼명 IN ( SELECT 컬럼명
FROM (SELECT 컬럼명, row_number() over(partition BY 컬럼 전체) AS rnum FROM 테이블명) t
WHERE t.rnum > 1);

DELETE FROM prj_wbs_inf
WHERE wbs_id IN ( SELECT wbs_id
FROM (SELECT wbs_id, row_number() over(partition BY  WBS_ID
          , PRJ_ID
          , SCH_ID
          , WBS_CD
          , WBS_NM
          , PRNT_WBS_ID
          , SEQ_NO
          , STATUS
          , WEIGHT_VALUE
          , START_DATE
          , END_DATE
          , RG_ID
          , RG_TS
          , UP_ID
          , UP_TS) AS rnum  FROM prj_wbs_inf) t
WHERE t.rnum > 1);