qy1.Open "select distinct xsrq from xszb ", cnn, adOpenStatic, adLo...

where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)and rowid not in (select min(rowid) from people group by peopleId having count(peopleId )>1)3、查找表中多余的重复记录（多个字段）select * from vitae a where (a.peopleId...