Sql Server 删除重复数据

DELETE T
FROM
(
SELECT *
, DupRank = ROW_NUMBER() OVER (
              PARTITION BY ID
              ORDER BY (SELECT NULL)
            )
FROM Table1
) AS T
WHERE DupRank > 1 

说明：Table1 为要删除表结构，ID为重复的数据