mssql 테이블 중복제거

identity seq 존재해야함

delete from TABLE_NAME

where

seq <  (select max(seq) from TABLE_NAME as A

where TABLE_NAME.비교컬럼=A.비교컬럼)

distinct 나 union 으로 검사