with
    e1 as
    (
        select
            EMP_CODE,
            replace(EMP_LAST_NAME, ' ', '') as l_name,
            replace(EMP_FIRST_NAME, ' ', '') as f_name
        from EMP
        where VALID_FLG = '1'
    ),
    e2 as
    (
        select
            l_name,
            f_name
        from e1
        group by
            l_name,
            f_name
        having
            count(l_name) > 1
            and count(f_name) > 1
        
    )
select
    EMP_CODE as CODE,
    EMP_LAST_NAME as SURNAME,
    EMP_FIRST_NAME as NAME
from
    EMP
left outer join e1 using(EMP_CODE)
where
    (l_name, f_name) in e2
order by l_name, EMP_CODE
;