SELECT EMP_CODE AS CODE
      ,EMP_LAST_NAME AS SURNAME
      ,EMP_FIRST_NAME AS NAME
  FROM EMP E1
 WHERE E1.VALID_FLG = '1'
   AND EXISTS(SELECT 1
                FROM EMP E2
               WHERE E2.VALID_FLG = '1' 
                 AND E1.EMP_CODE <> E2.EMP_CODE
                 AND replace(E1.EMP_LAST_NAME || E1.EMP_FIRST_NAME, ' ' , '') = replace(E2.EMP_LAST_NAME || E2.EMP_FIRST_NAME, ' ' , '')
             )
ORDER BY replace(EMP_LAST_NAME || EMP_FIRST_NAME, ' ' , ''), EMP_CODE