SELECT
    EMP_CODE AS CODE,
    EMP_LAST_NAME AS SURNAME,
    EMP_FIRST_NAME AS NAME
FROM
    EMP
WHERE
    VALID_FLG = '1'
    AND
    REPLACE((EMP_LAST_NAME || EMP_FIRST_NAME), " ", "") IN (
        SELECT 
            REPLACE((EMP_LAST_NAME || EMP_FIRST_NAME), " ", "") AS NAME
        FROM
            EMP
        WHERE
            VALID_FLG = "1"
        GROUP BY
            NAME
        HAVING COUNT(*) >= 2
        )
ORDER BY
    REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME, " ", "") ASC,
    EMP_CODE ASC;