SELECT EMP_CODE AS CODE, EMP_LAST_NAME AS SURNAME, EMP_FIRST_NAME AS NAME
FROM EMP AS A
WHERE 
    VALID_FLG = "1"
    AND EXISTS (
        SELECT EMP_CODE
        FROM EMP AS B
        WHERE REPLACE(A.EMP_LAST_NAME, " ", "") = REPLACE(B.EMP_LAST_NAME, " ", "")
            AND REPLACE(A.EMP_FIRST_NAME, " ", "") = REPLACE(B.EMP_FIRST_NAME, " ", "")
            AND A.EMP_CODE <> B.EMP_CODE
            AND B.VALID_FLG = "1"
    )
ORDER BY REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME, " ", ""), EMP_CODE