有条件的查询表元素多个字段重复的数据

例如
查询 md_area表中mdm_id与area_name_en字段相同的数据并且状态为is_active =1。
select * from md_area a
where (a.mdm_id,a.area_name_en) in (select mdm_id,area_name_en from md_area WHERE is_active =1 group by mdm_id,area_name_en having count(mdm_id) > 1)