<br />查询及删除重复记录的方法<br />(一)<br />1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断<br />select * from people<br />where peopleId in (select  peopleId  from  people  group  by  peopleId  having  count(peopleId) > 1)<br /><br />2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留

<br /><br />INSERT INTO  t_info_whitelist_copy<br />SELECT *,count(distinct telephone) FROM `t_info_whitelist` group by telephone;<br /> <br /> <br />insert into t_info_whitelist select * from t_info_whitelist_copy;