SELECT
	EMP_CODE AS CODE,
	EMP_LAST_NAME AS SURNAME,
	EMP_FIRST_NAME AS NAME
FROM
	EMP E
WHERE
	EXISTS( SELECT EMP_CODE
			  FROM EMP E2
			 WHERE REPLACE(E.EMP_LAST_NAME, ' ', '') = REPLACE(E2.EMP_LAST_NAME, ' ', '')
			   AND REPLACE(E.EMP_FIRST_NAME, ' ', '') = REPLACE(E2.EMP_FIRST_NAME, ' ', '')
			   AND E.EMP_CODE <> E2.EMP_CODE
               AND E2.VALID_FLG = '1'
	)
AND VALID_FLG = '1'
ORDER BY
	REPLACE(E.EMP_FIRST_NAME, ' ', ''),
	EMP_CODE
;