select count(studentcode),studentcode from gen_studentinfo2 group by studentcode having count(studentcode) > 1
select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
select count(studentcode),studentcode from gen_studentinfo2 group by studentcode having count(studentcode) > 1
select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)