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) 

 posted on 2015-09-08 10:30  代码改变世界&1024  阅读(523)  评论(0)  编辑  收藏  举报