SELECT 
    e1.EMP_CODE AS CODE,
    e1.EMP_LAST_NAME AS SURNAME,
    e1.EMP_FIRST_NAME AS NAME
FROM 
    EMP e1
JOIN 
    EMP e2
ON 
    REPLACE(e1.EMP_LAST_NAME, ' ', '') = REPLACE(e2.EMP_LAST_NAME, ' ', '') 
    AND REPLACE(e1.EMP_FIRST_NAME, ' ', '') = REPLACE(e2.EMP_FIRST_NAME, ' ', '') 
    AND e1.EMP_CODE != e2.EMP_CODE
WHERE
    e1.VALID_FLG = '1' AND e2.VALID_FLG = '1'
ORDER BY
    REPLACE(e1.EMP_LAST_NAME || e1.EMP_FIRST_NAME, ' ', '') ASC,
    e1.EMP_CODE ASC;