SELECT
  e1.EMP_CODE AS CODE
  ,e1.EMP_LAST_NAME AS SURNAME
  ,e1.EMP_FIRST_NAME AS NAME
FROM EMP e1
INNER JOIN EMP e2
  ON REPLACE(e1.EMP_LAST_NAME,' ','') || REPLACE(e1.EMP_FIRST_NAME,' ','')
       = REPLACE(e2.EMP_LAST_NAME,' ','') || REPLACE(e2.EMP_FIRST_NAME,' ','')
  AND e1.EMP_CODE <> e2.EMP_CODE
  AND e2.VALID_FLG = '1'
WHERE
  e1.VALID_FLG = '1'
ORDER BY
  REPLACE(e1.EMP_LAST_NAME,' ','') || REPLACE(e1.EMP_FIRST_NAME,' ','') asc
  ,e1.EMP_CODE asc