Sql Server 删除重复数据

?

1 2 3 4 5 6 7 8 9 10 11

DELETE T FROM ( SELECT * , DupRank = ROW_NUMBER() OVER (               PARTITION BY ID               ORDER BY (SELECT NULL)             ) FROM Table1 ) AS T WHERE DupRank > 1 <br><br>说明：Table1 为要删除表结构，ID为重复的数据