学步园

select *  from hr_basicinfo b
where b.id_card_no in (
select id_card_no from hr_basicinfo group by id_card_no having count(*) >1
)order by b.id_card_no desc