with TMP_EMP as (
    select
        EMP_CODE as CODE,
        EMP_LAST_NAME as SURNAME,
        EMP_FIRST_NAME as NAME,
        REPLACE(EMP_LAST_NAME, " ", "") || " " || REPLACE(EMP_FIRST_NAME, " ", "") as FULL_NAME
    from
        EMP
    where
        VALID_FLG ='1'
)

select
    CODE,
    SURNAME,
    NAME
from 
   TMP_EMP
where
    FULL_NAME in (
        select
            FULL_NAME
        from 
            TMP_EMP
        group by
            FULL_NAME
        having
            count(*) > 1
    )
order by
    REPLACE(SURNAME, " ", ""),
    CODE;