DELETE
FROM
gg_emails
WHERE
id IN (
SELECT
id
FROM
( SELECT * FROM gg_emails WHERE email IN ( SELECT email FROM gg_emails GROUP BY email HAVING count( id ) > 1 ) ORDER BY email ) t
)
AND id NOT IN (
SELECT
id
FROM
( SELECT max( id ) id FROM gg_emails GROUP BY email HAVING count(*) > 1 ) s)
注:
替换表名 :gg_emails
替换字段名:email