-
DELETE FROM {TableName}
-
-
WHERE {SEQColumnName} IN (
-
SELECT X.{SEQColumnName} AS IDX
-
FROM {Table_Name} X,
-
(SELECT Max({SEQColumnName}) AS IDX, {ColumnName} AS {ColumnNameAlias} , COUNT(*) AS CNT
-
FROM {TableName}
-
GROUP BY {ColumnName} HAVING COUNT(*) >1) Y
-
WHERE
-
X.{ColumnName}= Y.{ColumnName} AND
-
X.{SEQColumnName}!=Y.IDX
-
)
-
Note.
{ColumnName}의 값이 같은 데이터는 하나만 남기고 모두 지운다.
(0) 
(0)
