select
E1.EMP_CODE as CODE,
E1.EMP_LAST_NAME as SURNAME,
E1.EMP_FIRST_NAME as NAME
from
	EMP E1
inner join
	EMP E2
on
    E1.VALID_FLG = '1' and
    E2.VALID_FLG = '1' and
	replace(E1.EMP_LAST_NAME,' ','') = replace(E2.EMP_LAST_NAME,' ','') and
	replace(E1.EMP_FIRST_NAME,' ','') = replace(E2.EMP_FIRST_NAME,' ','') and
	E1.EMP_CODE <> E2.EMP_CODE
order by
	replace(E1.EMP_LAST_NAME,' ','') asc,
	replace(E1.EMP_FIRST_NAME,' ','') asc,
	E1.EMP_CODE asc