select * from a_person t
where t.phone in (select b.phone from a_person b group by b.phone having count(b.phone) > 1) order by t.phone desc
oracle查询重复记录
最新推荐文章于 2024-08-17 22:34:52 发布
select * from a_person t
where t.phone in (select b.phone from a_person b group by b.phone having count(b.phone) > 1) order by t.phone desc