with a as(
select EMP_CODE, replace(EMP_LAST_NAME, ' ', '') as la, replace(EMP_FIRST_NAME, ' ', '') as fi, replace(EMP_LAST_NAME, ' ', '')||replace(EMP_FIRST_NAME, ' ', '') as name  from EMP where VALID_FLG='1'
), b as (
select name, count(*) from a
group by name
having count(*) > 1
), c as(
select * from a
where name in (select name from b)
)

select * from EMP
where EMP_CODE in (select EMP_CODE from c)
;