SELECT
    t.EMP_CODE AS CODE
    ,t.EMP_LAST_NAME AS SURNAME
    ,t.EMP_FIRST_NAME AS NAME
FROM EMP t
    join EMP t1
        on replace(t.EMP_LAST_NAME,' ','') = replace(t1.EMP_LAST_NAME,' ','')
            and replace(t.EMP_FIRST_NAME,' ','') = replace(t1.EMP_FIRST_NAME,' ','')
WHERE t.VALID_FLG = '1'
    and t1.VALID_FLG = '1'
    and t.EMP_CODE <> t1.EMP_CODE
ORDER BY replace(t.EMP_LAST_NAME,' ','')
    ,replace(t.EMP_FIRST_NAME,' ','')
    ,t.EMP_CODE