select
    t1.EMP_CODE as CODE
    ,t1.EMP_LAST_NAME as SURNAME
    ,t1.EMP_FIRST_NAME as NAME
from EMP t1
    inner join (select * from EMP where VALID_FLG = '1') t2
    on replace(t1.EMP_LAST_NAME,' ','') =  replace(t2.EMP_LAST_NAME,' ','')
    and replace(t1.EMP_FIRST_NAME,' ','') = replace(t2.EMP_FIRST_NAME,' ','')
    and t1.EMP_CODE != t2.EMP_CODE
where t1.VALID_FLG = '1' 
order by 
    replace(t1.EMP_LAST_NAME,' ','')
    ,replace(t1.EMP_FIRST_NAME,' ','')
    ,t1.EMP_CODE