SELECT 
 EMP1.EMP_CODE AS CODE,
 EMP1.EMP_LAST_NAME AS SURNAME,
 EMP1.EMP_FIRST_NAME AS NAME
FROM EMP   EMP1
  INNER JOIN (
SELECT
  REPLACE(EMP_LAST_NAME, ' ', '') || REPLACE(EMP_FIRST_NAME, ' ', '') AS N_NAME
FROM EMP
WHERE VALID_FLG = '1'
GROUP BY N_NAME
HAVING  COUNT(N_NAME) > 1
 ) EMP2
ON EMP2.N_NAME = REPLACE(EMP1.EMP_LAST_NAME, ' ', '') || REPLACE(EMP1.EMP_FIRST_NAME, ' ', '')
ORDER BY REPLACE(EMP1.EMP_LAST_NAME, ' ', '') || REPLACE(EMP1.EMP_FIRST_NAME, ' ', ''), CODE