SELECT
	e1.EMP_CODE AS CODE,
	e1.EMP_LAST_NAME AS SURNAME,
	e1.EMP_FIRST_NAME AS NAME
FROM
	EMP e1
	INNER JOIN EMP e2
		ON REPLACE(e1.EMP_LAST_NAME, ' ', '') = REPLACE(e2.EMP_LAST_NAME, ' ', '') 
		AND REPLACE(e1.EMP_FIRST_NAME, ' ', '') = REPLACE(e2.EMP_FIRST_NAME, ' ', '')
WHERE
	e1.VALID_FLG = 1
ORDER BY
	REPLACE(e1.EMP_LAST_NAME, ' ', ''),
	e1.EMP_CODE