weixin_42731092的博客

DELETE FROM 表名 WHERE (字段名1,字段名2,字段名3) IN (SELECT 字段名1,字段名2,字段名3 FROM (SELECT 字段名1,字段名2,字段名3 FROM 表名 GROUP BY 字段名1,字段名2,字段名3 HAVING COUNT(*)>1) t1) AND id NOT IN (SELECT id FROM (SELECT MAX(id) FROM 表名 GROUP BY 字段名1,字段名2,字段名3 HAVING COUNT(*)>1) t2); .