sql server删除重复的数据


delete t from
(Select Row_Number() Over(Partition By [重复的字段] order By [唯一索引如：主键ID]) As rorwsnum* From 表名) t Where t.rorwsnum> 1

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/itBlogToYpl/p/15239256.html