Sql 根据多条件查询重复的数据 MySQL删除重复数据

   DELETE FROM bom WHERE Id IN(
  SELECT v.id FROM (SELECT MIN(b.id) id FROM bom b GROUP BY b.FGSFGCode,b.SFGMCode,b.factoryId HAVING COUNT(*) > 1) v)