select
    EMP_CODE as CODE
    , EMP_LAST_NAME as SURNAME
    , EMP_FIRST_NAME as NAME
from EMP as E1
where VALID_FLG='1'
    and exists (select * from EMP as E2 
            where E2.VALID_FLG='1' 
                and E1.EMP_CODE<>E2.EMP_CODE
                and replace(E1.EMP_LAST_NAME, ' ', '')=replace(E2.EMP_LAST_NAME, ' ', '')
                and replace(E1.EMP_FIRST_NAME, ' ', '')=replace(E2.EMP_FIRST_NAME, ' ', ''))
order by 
    replace(SURNAME, ' ', '')
    , replace(NAME, ' ', '')
    , CODE
;