#第一步 SELECT * FROM user a GROUP BY a.card_id,a.phone HAVING COUNT() > 1; #第二步 SELECT t.id FROM (SELECT * FROM user a GROUP BY a.card_id,a.phone HAVING COUNT() > 1) AS t; #第三步 DELETE FROM user WHERE id IN (SELECT t.id FROM (SELECT * FROM user a GROUP BY a.card_id,a.phone HAVING COUNT(*) > 1) AS t);