select
    e1.EMP_CODE as 'CODE'
    , e1.EMP_LAST_NAME as 'SURNAME'
    , e1.EMP_FIRST_NAME as 'NAME'
from
    EMP e1
    join EMP e2
        on replace(e1.EMP_LAST_NAME, ' ', '') = replace(e2.EMP_LAST_NAME, ' ', '')
        and replace(e1.EMP_FIRST_NAME, ' ', '') = replace(e2.EMP_FIRST_NAME, ' ', '')
        and e1.EMP_CODE <> e2.EMP_CODE
where
    e1.VALID_FLG = '1'
    and e2.VALID_FLG = '1'
order by
    replace(e1.EMP_LAST_NAME, ' ', '')||replace(e1.EMP_FIRST_NAME, ' ', '')
    , e1.EMP_CODE
;