DELETE FROM
表名 WHERE
重复字段 IN
(
SELECT a.id FROM
(
SELECT MAX(
重复字段) id FROM
表名 a WHERE EXISTS
(
SELECT 1 FROM
表名 b WHERE a.
重复字段=b.
重复字段 GROUP BY
重复字段 HAVING COUNT(1)>1
)
GROUP BY
重复字段
) a
)
例如:
DELETE FROM
sxpinews WHERE
newsnum IN
(
SELECT a.id FROM
(
SELECT MAX(
newsnum) id FROM
sxpinews a WHERE EXISTS
(
SELECT 1 FROM
sxpinews b WHERE a.
newsnum=b.
newsnum GROUP BY
newsnum HAVING COUNT(1)>1
)
GROUP BY newsnum
) a
)