select
	distinct
	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
	trim(replace(E1.EMP_LAST_NAME,' ','')) = trim(replace(E2.EMP_LAST_NAME,' ','')) and
	trim(replace(E1.EMP_FIRST_NAME,' ','')) = trim(replace(E2.EMP_FIRST_NAME,' ','')) and
	E1.EMP_CODE <> E2.EMP_CODE
order by
	trim(replace(E1.EMP_LAST_NAME,' ','')) asc,
	trim(replace(E1.EMP_FIRST_NAME,' ','')) asc,
	E1.EMP_CODE asc