select E.EMP_CODE CODE
, E.EMP_LAST_NAME SURNAME
, E.EMP_FIRST_NAME NAME
from EMP E
     inner join (
        select
         replace(E0.EMP_LAST_NAME, " ","") EMP_LAST_NAME
        ,  replace(E0.EMP_FIRST_NAME, " ","") EMP_FIRST_NAME
        from EMP E0
        where E0.VALID_FLG = '1'
        group by
         replace(E0.EMP_LAST_NAME, " ","")
        ,  replace(E0.EMP_FIRST_NAME, " ","")
        having count(*) > 1
     ) t
       on t.EMP_LAST_NAME = replace(E.EMP_LAST_NAME, " ","") 
       and t.EMP_FIRST_NAME = replace(E.EMP_FIRST_NAME, " ","")
order by
 replace(E.EMP_LAST_NAME, " ","") 
, replace(E.EMP_FIRST_NAME, " ","")
, E.EMP_CODE