SELECT
    B.CODE,
    B.SURNAME,
    B.NAME
FROM
    (
    SELECT
        EMP.EMP_CODE AS CODE,
        EMP_LAST_NAME AS SURNAME,
        EMP_FIRST_NAME AS NAME,
        REPLACE(EMP_LAST_NAME, ' ', '') || REPLACE(EMP_FIRST_NAME, ' ', '') AS FULLN
    FROM
        EMP
    INNER JOIN
        (
        SELECT
            FULL.FULLNAME
        FROM
            (
            SELECT
                EMP_CODE,
                REPLACE(EMP_LAST_NAME, ' ', '') || REPLACE(EMP_FIRST_NAME, ' ', '') AS FULLNAME
            FROM
                EMP
            WHERE
                EMP.VALID_FLG = 1
            ) AS FULL
        GROUP BY
            FULL.FULLNAME
        HAVING
            COUNT(FULL.FULLNAME) > 1
        ) AS A
    ON
        FULLN = A.FULLNAME
    WHERE
        EMP.VALID_FLG = 1
    ORDER BY
        FULLN,
        CODE
    ) AS B