查询表中重复数据

 

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)