WITH A AS(
SELECT
	REPLACE(EMP_FIRST_NAME, ' ', '') AS NAME2
	,REPLACE(EMP_LAST_NAME, ' ', '') AS NAME1
	,COUNT(REPLACE(EMP_LAST_NAME, ' ', '')) AS CNT
FROM
	EMP
WHERE
	VALID_FLG = '1'
GROUP BY
	REPLACE(EMP_LAST_NAME, ' ', ''), REPLACE(EMP_FIRST_NAME, ' ', '')
)
SELECT
	EMP_CODE AS CODE
	,EMP_LAST_NAME AS SURNAME
	,EMP_FIRST_NAME AS NAME
FROM
	EMP
	INNER JOIN A ON REPLACE(EMP_LAST_NAME, ' ', '') = NAME1 AND REPLACE(EMP_FIRST_NAME, ' ', '') = NAME2 AND CNT > 1
WHERE VALID_FLG = '1'
ORDER BY 
	REPLACE(SURNAME, ' ', '') || REPLACE(NAME, ' ', '')
	,CODE