sqlserver删除重复数据 迁移数据库的时候使用了Navicat传输,却不小心传入了两遍相同的数据,如何删掉多余的数据,用到下面的这个语句,非常简单,只需要替换对应的字段即可。 WITH CTE AS ( SELECT UnitId, Unit, ROW_NUMBER() OVER (PARTITION BY Unit ORDER BY UnitId) AS row_num FROM Maintain_Unit ) DELETE FROM CTE WHERE row_num > 1;