SQL重复记录查询方法2008年08月14日 星期四 21:01SQL重复记录查询1查找表中多余的重复记录重复记录是根据单个字段(peopleId)来判断select from peoplewhere peopleId in (select?? peopleId from?? people group by?? peopleId having count(peopleId) > 1)2删除