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 으로 검사