SELECT  EMP1.EMP_CODE AS CODE,
        EMP1.EMP_LAST_NAME AS SURNAME,
        EMP1.EMP_FIRST_NAME AS NAME
FROM    EMP EMP1
WHERE   EMP1.VALID_FLG = '1'
AND     REPLACE(EMP1.EMP_LAST_NAME || EMP1.EMP_FIRST_NAME, ' ','') IN
       (SELECT REPLACE(EMP2.EMP_LAST_NAME || EMP2.EMP_FIRST_NAME, ' ','')
        FROM   EMP EMP2
        WHERE  EMP2.VALID_FLG = '1'
        AND    EMP2.EMP_CODE != EMP1.EMP_CODE)
ORDER BY REPLACE(EMP1.EMP_LAST_NAME || EMP1.EMP_FIRST_NAME, ' ','') ,EMP1.EMP_CODE