MS SQL 중복값제거하기

-- 중복 데이터 확인
      SELECT  Title, COUNT(*) AS CNT
         FROM  TableName
  GROUP BY  Title
      HAVING  COUNT(*) > 1

-- 결과
Title   CNT
----   ---
1        5
2        4
3        2.

(3개 행 적용됨)

-- 실행
SELECT  COUNT(*)
   FROM  TableName
-- DELETE TableName
 WHERE  Seq NOT IN (SELECT  MAX(Seq)
                                    FROM  TableName
                             GROUP BY  Title)