删除mssql中的重复数据
DELETE T
FROM
(
SELECT *
, DupRank = ROW_NUMBER() OVER (
PARTITION BY datacol
ORDER BY (SELECT NULL)
)
FROM datatable
) AS T
WHERE DupRank > 1
DELETE T
FROM
(
SELECT *
, DupRank = ROW_NUMBER() OVER (
PARTITION BY datacol
ORDER BY (SELECT NULL)
)
FROM datatable
) AS T
WHERE DupRank > 1