DELETE
FROM
表名
WHERE 主键 IN
(SELECT
主键
FROM
(SELECT
a.主键
FROM
表名 a
WHERE a.需要判断重复的列 IN
(SELECT
s.需要判断重复的列
FROM
表名 s
GROUP BY s.需要判断重复的列
HAVING COUNT(1) > 1)
AND a.主键 NOT IN
(SELECT
MIN(s.主键)
FROM
表名 s
GROUP BY s.需要判断重复的列
HAVING COUNT(s.需要判断重复的列) > 1)) AS 临时表名)
非Mysql数据库可不用 AS 临时表