SELECT EMP_CODE CODE
      ,EMP_LAST_NAME SURNAME
      ,EMP_FIRST_NAME NAME
  FROM EMP
 WHERE REPLACE(EMP_LAST_NAME,' ','')||REPLACE(EMP_FIRST_NAME,' ','') IN
(
SELECT C1
  FROM
(
SELECT REPLACE(EMP_LAST_NAME,' ','')||REPLACE(EMP_FIRST_NAME,' ','') C1
      ,COUNT(*) C2
  FROM EMP
 GROUP BY REPLACE(EMP_LAST_NAME,' ',''),REPLACE(EMP_FIRST_NAME,' ','')
HAVING C2>1
ORDER BY C1
)
)
ORDER BY REPLACE(EMP_LAST_NAME,' ','')||REPLACE(EMP_FIRST_NAME,' ','')
        ,EMP_CODE
;