SQL Server中删除重复数据

delete from A
where UserName in (select UserName from A group by UserName having count(UserName)>1)
and UserID not in (select min(UserID) from A group by UserName having count(UserName)>1)
View Code
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/zuimeideshi520/p/6025493.html