select
    ep.EMP_CODE        AS 'CODE'
    ,ep.EMP_LAST_NAME  AS 'SURNAME'
    ,ep.EMP_FIRST_NAME AS 'NAME'
from
    EMP ep
inner join
    (select
        REPLACE(EMP_LAST_NAME,' ','') as rp_SURNAME
        , REPLACE(EMP_FIRST_NAME,' ','') as rp_NAME
        , count(*) as cnt
     from
        EMP
     where 
        VALID_FLG = 1
     group by
        rp_SURNAME
        , rp_NAME
     having 
        cnt > 1
    ) rp
    on  REPLACE(ep.EMP_LAST_NAME,' ','')  = rp.rp_SURNAME
    and REPLACE(ep.EMP_FIRST_NAME,' ','') = rp.rp_NAME
where
    ep.VALID_FLG = 1
order by 
    rp.rp_SURNAME
    ,rp.rp_NAME
    ,ep.EMP_CODE