with valid_emp_exc_space as(
    select
        EMP_CODE
        , EMP_LAST_NAME
        , EMP_FIRST_NAME
        , replace(EMP_LAST_NAME, " ", "")||replace(EMP_FIRST_NAME, " ", "") as 'FULL_NAME_EXC_SPACE'
    from
        EMP
    where
        VALID_FLG = '1'
)
select
    distinct(v1.EMP_CODE) as 'CODE'
    , v1.EMP_LAST_NAME as 'SURNAME'
    , v1.EMP_FIRST_NAME as 'NAME'
from
    valid_emp_exc_space v1
    inner join valid_emp_exc_space v2 
        on v1.FULL_NAME_EXC_SPACE = v2.FULL_NAME_EXC_SPACE
        and v1.EMP_CODE != v2.EMP_CODE
order by
    v1.FULL_NAME_EXC_SPACE asc
    , v1.EMP_CODE asc
;