SELECT EMP.EMP_CODE AS CODE
      ,EMP.EMP_LAST_NAME AS SURNAME
      ,EMP.EMP_FIRST_NAME AS NAME
FROM   EMP
WHERE VALID_FLG = '1'
  AND REPLACE(EMP_LAST_NAME||EMP_FIRST_NAME, ' ', '') IN (SELECT REPLACE(EMP_LAST_NAME||EMP_FIRST_NAME, ' ', '') AS EMP_NAME
                                                          FROM   EMP
                                                          WHERE  VALID_FLG = '1'
                                                          GROUP BY EMP_NAME
                                                          HAVING   COUNT(*) > 1)
ORDER BY REPLACE(EMP_LAST_NAME||EMP_FIRST_NAME, ' ', '') ASC
        ,CODE ASC