WITH table1 AS(
SELECT
    EMP_CODE AS CODE
    ,REPLACE(EMP_LAST_NAME, ' ', '') AS SURNAME
    ,REPLACE(EMP_FIRST_NAME, ' ', '') AS NAME
    ,REPLACE(EMP_LAST_NAME, ' ', '')||REPLACE(EMP_FIRST_NAME, ' ', '') AS FULLNAME
FROM EMP
),

table2 AS(
SELECT 
    FULLNAME
    ,COUNT(CODE) AS match_name_cnt
FROM table1
GROUP BY 1
HAVING match_name_cnt > 1
)


SELECT
    CODE
    ,SURNAME
    ,NAME
FROM table1
WHERE FULLNAME IN (SELECT FULLNAME FROM table2)
ORDER BY 2,1;