DELETE
FROM table表
WHERE
(
table表 字段
) IN (
SELECT FROM(
SELECT
table表 字段
FROM
table表 as 别名
GROUP BY
别名.table表 字段
HAVING
count() > 1
) as c)
AND id NOT IN (
SELECT from(
SELECT
min(id) //最小的记录
FROM
table表 as 别名
GROUP BY
别名.table表 字段
HAVING
count() > 1
)as d )