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 as l_name2,
            f_name as f_name2
        from e1
        group by
            l_name,
            f_name
        having
            count(l_name) > 1
            and count(f_name) > 1
        
    )
select
    EMP_CODE as CODE,
    l_name as SURNAME,
    f_name as NAME
from
    e1
where
    (l_name, f_name) in e2
order by l_name, EMP_CODE
;