03 2024 档案
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 为要删除表
阅读全文