select A.EMP_CODE as CODE
        ,A.EMP_LAST_NAME as SURNAME
        ,A.EMP_FIRST_NAME  as NAME
from emp as A
inner join emp as B
 on  replace(A.EMP_LAST_NAME,' ','') = replace(B.EMP_LAST_NAME,' ','')
 and replace(A.EMP_FIRST_NAME,' ','') = replace(B.EMP_FIRST_NAME,' ','')
 and A.EMP_CODE <> B.EMP_CODE
 and A.VALID_FLG = '1'
 and B.VALID_FLG = '1'
order by replace(A.EMP_LAST_NAME,' ','') = replace(B.EMP_LAST_NAME,' ','')
        ,replace(A.EMP_FIRST_NAME,' ','') = replace(B.EMP_FIRST_NAME,' ','') 
        ,NAME,CODE