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