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
筛选出相同的数据
最新推荐文章于 2023-06-14 11:15:07 发布
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