SELECT EMP_CODE AS 'CODE'
	, EMP_LAST_NAME AS 'SURNAME'
	, EMP_FIRST_NAME AS 'NAME'
FROM EMP AS emp1
WHERE VALID_FLG = '1'
	AND EXISTS (
		SELECT *
		FROM EMP AS emp2
		WHERE emp2.EMP_CODE != emp1.EMP_CODE
			AND REPLACE(emp2.EMP_LAST_NAME, ' ', '') = REPLACE(emp1.EMP_LAST_NAME, ' ', '')
			AND REPLACE(emp2.EMP_FIRST_NAME, ' ', '') = REPLACE(emp1.EMP_FIRST_NAME, ' ', '')
			AND VALID_FLG = '1'
		)
ORDER BY 
		REPLACE(emp1.EMP_LAST_NAME, ' ', '') || REPLACE(emp1.EMP_FIRST_NAME, ' ', '')
	, EMP_CODE