如何使用删除sql server数据库中的重复行？

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

-- 创建临时表
SELECT column1, column2, ...
INTO #temp_table
FROM your_table;

-- 清空目标表
TRUNCATE TABLE your_table;

-- 插入不重复行
INSERT INTO your_table
SELECT DISTINCT column1, column2, ...
FROM #temp_table;

-- 删除临时表
DROP TABLE #temp_table;

DELETE FROM your_table
WHERE (column1, column2, ...) IN (
    SELECT column1, column2, ...
    FROM your_table
    GROUP BY column1, column2, ...
    HAVING COUNT(*) > 1
);