select 
    EMP_CODE as CODE,
    EMP_LAST_NAME as SURNAME,
    EMP_FIRST_NAME as NAME
from 
    EMP as EMP1
where
    exists(
        select 
            *
        from
            EMP as EMP2
        where
            EMP1.EMP_CODE != EMP2.EMP_CODE
            and Replace(EMP1.EMP_LAST_NAME || EMP1.EMP_FIRST_NAME, " ", "") = Replace(EMP2.EMP_LAST_NAME || EMP2.EMP_FIRST_NAME, " ", "")
            and VALID_FLG = "1"
    )
    and VALID_FLG = "1"
order by
    Replace(EMP_LAST_NAME || EMP_FIRST_NAME, " ", ""),
    EMP_CODE;