1、查询和删除同一表内一个或多个字段重复记录的SQL语句 比如现在有一人员表 (表名:peosons)若想将姓名、身份证号、住址这三个字段完全相同的记录查询出来select p1.* from persons p1,persons p2 where p1.id<>p2.id and p1.cardid = p2.cardid and p1.pname = p2.pname and p1.address = p2.address可以实现上述效果.几个删除重复记录的SQL语句 1.用rowid方法2.用groupby方法3.用distinct方法
4、istinct* fromtable1minuxtruncatetabletable1;insertintotable1select*fromtable_new;查询及删除重复记录的方法大全1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断select*frompeoplewherepeopleIdin(select peopleId from people group by peopleId having count(peopleId)>1)2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来
5、判断,只留有rowid最小的记录deletefrompeoplewherepeopleId in(select peopleId frompeople group by peopleId having count(peopleId)>1)androwidnotin(selectmin(rowid)from people groupbypeopleId havingcount(peopleId)>1)3、查找表中多余的重复记录(多个字段)select*fromvitaeawhere(a.peopleId,a.seq)in (selectpeo