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