SELECT voter.SrNo, voter.YadiNo, voter.fullname, voter.houseno, voter.address, voter.Gender, voter.Age, voter.CardNo
FROM voter where voter.YadiNo in (select voter.YadiNo from Voter group by Voter.houseno And Voter.address)
I Think It Will Work Please Try It,,Please Give Reply Its Working Or Not