Mssql 删除某表的重复数据 开发过程中经常使用到,这边记录一下,供大家参考 delete A2 from ( select row_Number() over(partition by [根据哪个字段去重] order by [根据哪个字段排序]) as keyId_e,* from [表名] ) as A2 where A2.keyId_e >1