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 trim(replace(t.EMP_LAST_NAME,' ','')) = trim(replace(t1.EMP_LAST_NAME,' ',''))
            and trim(replace(t.EMP_FIRST_NAME,' ','')) = trim(replace(t1.EMP_FIRST_NAME,' ',''))
            and t.EMP_CODE <> t1.EMP_CODE
WHERE t.VALID_FLG = '1' and t1.VALID_FLG = '1'
ORDER BY replace(t.EMP_LAST_NAME,' ','')
    ,replace(t.EMP_FIRST_NAME,' ','')
    ,t.EMP_CODE