去掉重复字段且保留一条 DELETE FROM 表A WHERE id NOT IN ( SELECT id FROM ( SELECT MIN(id) AS id FROM 表A WHERE 条件 GROUP BY 分组字段 ) AS temp_ids ) AND 条件’;