select
    EMP_CODE as CODE,
    EMP_LAST_NAME as SURNAME,
    EMP_FIRST_NAME as NAME
from
    EMP as outer_e
where
    replace(EMP_LAST_NAME, ' ', '') in (
        select
            replace(EMP_LAST_NAME, ' ', '')
        from
            EMP as inner_e
        where
            inner_e.EMP_CODE <> outer_e.EMP_CODE
            and
            VALID_FLG = '1'
    )
    and
    replace(EMP_FIRST_NAME, ' ', '') in (
        select
            replace(EMP_FIRST_NAME, ' ', '')
        from
            EMP as inner_e
        where
            inner_e.EMP_CODE <> outer_e.EMP_CODE
            and
            VALID_FLG = '1'
    )
    and
    VALID_FLG = '1'
order by
    replace(EMP_LAST_NAME, ' ', ''),
    replace(EMP_FIRST_NAME, ' ', ''),
    EMP_CODE;