WITH CleanedData AS (
    SELECT 
        EMP_CODE as CODE, 
        EMP_LAST_NAME as SURNAME, 
        EMP_FIRST_NAME as NAME, 
        REPLACE(EMP_LAST_NAME,' ', '') AS cleaned_surname, 
        REPLACE(EMP_FIRST_NAME,' ', '') AS cleaned_name
    FROM EMP
    WHERE VALID_FLG=1
)
SELECT 
    c.CODE, 
    c.SURNAME, 
    c.NAME
FROM 
    CleanedData c
INNER JOIN 
    CleanedData c2 ON c.cleaned_surname = c2.cleaned_surname 
                  AND c.cleaned_name = c2.cleaned_name 
                  AND c.CODE != c2.CODE
WHERE 
    (c.cleaned_surname, c.cleaned_name) IN (
        SELECT 
            cleaned_surname, cleaned_name
        FROM 
            CleanedData
        GROUP BY 
            cleaned_surname, cleaned_name
        HAVING 
            COUNT(*) > 1
    ) 
ORDER BY 
    c.cleaned_surname ASC, 
    c.cleaned_name ASC, 
    c.CODE ASC;