sql server 删除重复数据，保留一条

WITH TaskInfoWithRowNumber AS (
SELECT TaskId,
ROW_NUMBER() OVER (PARTITION BY TaskId ORDER BY (SELECT NULL)) AS row_number
FROM WH_TaskInfo
)
DELETE FROM TaskInfoWithRowNumber
WHERE row_number > 1;