with full as(
    select
        EMP_CODE c,
        replace(EMP_LAST_NAME, ' ', '') || replace(EMP_FIRST_NAME, ' ', '') fullname,
        EMP_LAST_NAME l,
        EMP_FIRST_NAME f
    from
        EMP
    where VALID_FLG = 1
)
select
    full.c CODE,
    full.l SURNAME,
    full.f NAME
from
    (
        select
            *
        from
            full
        group by
            fullname
        having
            COUNT(*) > 1
    ) tmp
    inner join full on tmp.fullname = full.fullname
order by
    full.fullname,
    full.c