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