SQL:
DELETE FROM article
WHERE id NOT IN (
SELECT *
FROM (
SELECT min(id)
FROM
article
GROUP BY
articleNo
HAVING
count(*) > 1
) a
)
AND articleNo IN (
SELECT *
FROM (
SELECT articleNo
FROM article
GROUP BY
articleNo
HAVING
count(*) > 1
) b
);
其中,“article”为表名,“articleNo”为不允许重复的字段名