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