sql删除多余重复的数据只保留一条

delete from people 
where   peopleName in (select peopleName    from people group by peopleName      having count(peopleName) > 1) 
and   peopleId not in (select min(peopleId) from people group by peopleName     having count(peopleName)>1) 

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