Sql删除表中多余的重复记录

删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录

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) 

如果 peopleId 是uniqueidentifier类型 则将

select min(peopleId) from people group by peopleName     having count(peopleName)>1

改为

select min(convert(varchar(36),peopleId)) from people group by peopleName     having count(peopleName)>1

Sql删除表中多余的重复记录

标签：group   重复   记录   bsp   min   字段   uniq   char   having