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