with wk as (
    select
        EMP_CODE,
        replace(EMP_LAST_NAME, ' ', '') AS EMP_LAST_NAME,
        replace(EMP_FIRST_NAME, ' ', '') AS EMP_FIRST_NAME
    from EMP
    where
        VALID_FLG = '1'
),
wk2 as (
    select distinct
        t1.EMP_CODE
    from wk as t1
    cross join wk as t2
    where
        t1.EMP_LAST_NAME = t2.EMP_LAST_NAME
        and t1.EMP_FIRST_NAME = t2.EMP_FIRST_NAME
        and t1.EMP_CODE <> t2.EMP_CODE
)
select
    EMP.EMP_CODE AS CODE,
    EMP_LAST_NAME AS SURNAME,
    EMP_FIRST_NAME AS NAME
from EMP
inner join wk2
on EMP.EMP_CODE = wk2.EMP_CODE
order by
    replace(EMP.EMP_LAST_NAME, ' ', ''),
    replace(EMP.EMP_FIRST_NAME, ' ', ''),
    EMP.EMP_CODE