select 
    E.EMP_CODE as CODE
    , E.EMP_LAST_NAME as SURNAME
    , 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'
order by E2.A,CODE