Program/MSSQL

mssql 테이블 중복제거

키클쥔장 2014. 9. 22. 15:21

identity seq 존재해야함



delete from TABLE_NAME

where

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

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



distinct 나 union 으로 검사