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
                trim(EMP_LAST_NAME || EMP_FIRST_NAME, ' ')
            FROM
                EMP
            WHERE
                VALID_FLG = 1
            GROUP BY
                replace(EMP_LAST_NAME || EMP_FIRST_NAME, ' ','')
            HAVING
                COUNT(*) >=2
            )
ORDER BY
    trim(EMP_LAST_NAME || EMP_FIRST_NAME, ' ') ASC
    ,CODE ASC;