중복데이터 제거

DELETE TB_DATE_IDXa FROM

(

SELECT

ROW_NUMBER() OVER (PARTITION BY HCODE_DT, KBNUM, BARCODE ORDER BY HCODE_DT) AS ROWNUM

FROM TB_DATE_IDX

) AS TB_DATE_IDXa

WHERE TB_DATE_IDXa.ROWNUM > 1