查找表中的重复数据

 

select *
  from person
 where id in
 (
    select id
      from person_main
     group by id
    having (count(*) > 1)
 )