select
	emp1.EMP_CODE as CODE,
	emp1.EMP_LAST_NAME as SURNAME,
	emp1.EMP_FIRST_NAME as NAME
from
	(select EMP_CODE,VALID_FLG,
			EMP_LAST_NAME,
			EMP_FIRST_NAME
	 from EMP) emp1
	 inner join 
	 	(select EMP_CODE,VALID_FLG,
			REPLACE(EMP_LAST_NAME, ' ', '') as EMP_LAST_NAME,
			REPLACE(EMP_FIRST_NAME, ' ', '') as EMP_FIRST_NAME
	 	from EMP) emp2
	 on  emp1.EMP_CODE <> emp2.EMP_CODE
	 and REPLACE(emp1.EMP_LAST_NAME, ' ', '')  = emp2.EMP_LAST_NAME
	 and REPLACE(emp1.EMP_FIRST_NAME, ' ', '') = emp2.EMP_FIRST_NAME
where
	emp1.VALID_FLG = '1'
and emp2.VALID_FLG = '1'
order by 
	emp2.EMP_LAST_NAME, emp1.EMP_CODE