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
	 where VALID_FLG = '1') 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
	 	where VALID_FLG = '1') 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
order by 
	emp2.EMP_LAST_NAME, emp1.EMP_CODE