SELECT T1.EMP_CODE AS CODE,
       T1.EMP_LAST_NAME AS SURNAME,
       T1.EMP_FIRST_NAME AS NAME
  FROM EMP T1 INNER JOIN (SELECT replace(EMP_LAST_NAME,' ','') AS SURNAME,
                                 replace(EMP_FIRST_NAME,' ','') AS NAME
                            FROM EMP
                           WHERE VALID_FLG = '1'
                           GROUP BY replace(EMP_LAST_NAME,' ',''),
                                    replace(EMP_FIRST_NAME,' ','')
                           HAVING COUNT(*) > 1
                         ) T2
                  ON replace(T1.EMP_LAST_NAME,' ','') = T2.SURNAME
                 AND replace(T1.EMP_FIRST_NAME,' ','') = T2.NAME
 WHERE T1.VALID_FLG = '1'             
ORDER BY replace(T1.EMP_LAST_NAME,' ','') || replace(T1.EMP_FIRST_NAME,' ','') ASC,
         T1.EMP_CODE ASC