MySQL删除重复数据

分类: 文章 • 2024-03-08 11:43:16

DELETE 
FROM
  dept 
WHERE db_source IN 
  (SELECT 
    db_source 
  FROM
    (SELECT 
      db_source 
    FROM
      dept 
    GROUP BY db_source 
    HAVING COUNT(db_source) > 1) a) 
  AND deptno NOT IN 
  (SELECT 
    db_source 
  FROM
    (SELECT 
      MIN(deptno) AS db_source
    FROM
      dept 
    GROUP BY db_source 
    HAVING COUNT(db_source) > 1) b)

原数据：

MySQL删除重复数据

删除后：

MySQL删除重复数据

MySQL删除重复数据

相关推荐