select 
    E.EMP_CODE as CODE
    , REPLACE(E.EMP_LAST_NAME,' ','') as SURNAME
    , REPLACE(E.EMP_FIRST_NAME,' ','') as NAME 
from EMP as E
  INNER JOIN ( 
    SELECT
        REPLACE(EMP_LAST_NAME,' ','') || REPLACE(EMP_FIRST_NAME,' ','') as A
    FROM
      EMP
    where VALID_FLG = '1'  
    GROUP BY
      A 
    HAVING
      COUNT(A) > 1
  ) E2
    ON REPLACE(E.EMP_LAST_NAME,' ','') || REPLACE(E.EMP_FIRST_NAME,' ','') = E2.A
where E.VALID_FLG = '1'
GROUP BY
  E2. A
HAVING
  COUNT(E2. A) > 1
order by A,NAME,CODE