如何删除SQL Server中的重复数据？

WITH CTE AS (
    SELECT *, ROW_NUMBER() OVER (PARTITION BY column1, column2, ... ORDER BY (SELECT NULL)) AS RowNum
    FROM your_table
)
DELETE FROM CTE WHERE RowNum > 1;

DELETE FROM your_table
WHERE EXISTS (
    SELECT 1 FROM your_table t2
    WHERE t2.column1 = your_table.column1
    AND t2.column2 = your_table.column2
    AND t2.primary_key_column <> your_table.primary_key_column
);