WITH CleanedData AS (
    SELECT 
        EMP_CODE as CODE, 
        SURNAME, 
        NAME, 
        REPLACE(SURNAME, ' ', '') AS cleaned_surname, 
        REPLACE(NAME, ' ', '') AS cleaned_name
    FROM EMP
)
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;