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 EMP_FULL_NAME
        FROM
            EMP
        WHERE
            VALID_FLG = 1
        GROUP BY
            EMP_FULL_NAME
        HAVING
            COUNT(*) >= 2
    )
ORDER BY
    REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME, " ", "") ASC
    , EMP_CODE ASC;