중복 데이터 삭제

1. word : 중복데이터 포함 필드

2. recno : 중복되지 않는 고유번호

3. tableName : 테이블명

4. 삭제 쿼리

DELETE FROM tableName

WHERE recno IN ( 

SELECT a.recno AS recno 

FROM tableName A INNER JOIN ( SELECT MAX(recno) AS recno, word, count(*) AS loginCount FROM tableName GROUP BY word HAVING count(*) >1) B

ON A.word = B.word and A.recno <> B.recno )