WITH subs as (
    SELECT
        REPLACE((EMP_LAST_NAME || EMP_FIRST_NAME), " ", "") AS FULL_NAME
    FROM
        EMP
    WHERE
        VALID_FLG = "1"
    GROUP BY
        REPLACE((EMP_LAST_NAME || EMP_FIRST_NAME), " ", "")
    HAVING
        COUNT(*) >= 2
)


SELECT
    EMP_CODE AS CODE,
    EMP_LAST_NAME AS SURNAME,
    EMP_FIRST_NAME AS NAME
FROM
    EMP
INNER JOIN
    subs
ON
    REPLACE((EMP_LAST_NAME || EMP_FIRST_NAME), " ", "") = subs.FULL_NAME
ORDER BY
    REPLACE((EMP_LAST_NAME || EMP_FIRST_NAME), " ", "") ASC,
    EMP_CODE ASC;