SELECT DISTINCT
	EMP1.EMP_CODE AS CODE
	,EMP1.EMP_LAST_NAME AS SURNAME
	,EMP1.EMP_FIRST_NAME AS NAME
FROM
	EMP EMP1, EMP EMP2
WHERE
	EMP1.VALID_FLG = '1'
	AND REPLACE(SURNAME, ' ', '') = REPLACE(EMP2.EMP_LAST_NAME, ' ', '')
	AND REPLACE(NAME, ' ', '') = REPLACE(EMP2.EMP_FIRST_NAME, ' ', '')
ORDER BY 
	REPLACE(SURNAME, ' ', '') || REPLACE(NAME, ' ', '')
	,CODE
;