select * from hr_org_dept where dept_name in(select dept_name from hr_org_dept group by dept_name having count(*)>1)