SELECT
  DISTINCT E1.EMP_CODE AS CODE,
  E1.EMP_LAST_NAME AS SURNAME,
  E1.EMP_FIRST_NAME AS NAME
FROM
  (
    SELECT
      *
    FROM
      EMP
    WHERE
      VALID_FLG = '1'
  ) AS E1
  INNER JOIN (
    SELECT
      *
    FROM
      EMP
    WHERE
      VALID_FLG = '1'
  ) AS E2 ON E1.EMP_CODE <> E2.EMP_CODE
  AND REPLACE(E1.EMP_LAST_NAME, ' ', '') = REPLACE(E2.EMP_LAST_NAME, ' ', '')
  AND REPLACE(E1.EMP_FIRST_NAME, ' ', '') = REPLACE(E2.EMP_FIRST_NAME, ' ', '')
ORDER BY
  REPLACE(E1.EMP_LAST_NAME, ' ', ''),
  REPLACE(E1.EMP_FIRST_NAME, ' ', ''),
  E1.EMP_CODE