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
    GROUP BY
      A 
    HAVING
      COUNT(A) > 1
  ) E2
    ON E.EMP_LAST_NAME || E.EMP_FIRST_NAME = E2.EMP_LAST_NAME || E2.EMP_FIRST_NAME
where VALID_FLG ＝ '1'
order by A,NAME,CODE