sqlserver删除重复数据

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;