with t1 as (
    select
        EMP_CODE,
        replace(EMP_LAST_NAME, " ", "") as L,
        replace(EMP_FIRST_NAME, " ", "") as F
    from
        EMP
    where
        EMP.VALID_FLG == "1"
),
t2 as (
    select
        t.EMP_CODE as EMP_CODE,
        t.L,
        t.F
    from
        t1 as t,
        t1
    where
        t.L == t1.L
        and t.EMP_CODE != t1.EMP_CODE
        and t.F == t1.F
    group by
        t.EMP_CODE
)
select
    EMP.EMP_CODE as CODE,
    EMP.EMP_LAST_NAME as SURNAME,
    EMP.EMP_FIRST_NAME as NAME
from
    EMP,
    t2
where
    EMP.EMP_CODE == t2.EMP_CODE
order by
    t2.L,
    t2.F,
    EMP.EMP_CODE