SELECT 
 A.EMP_CODE AS CODE
,A.EMP_LAST_NAME AS SURNAME
,A.EMP_FIRST_NAME AS NAME
FROM EMP A
,(
	SELECT EMP_LAST_NAME,EMP_FIRST_NAME,EMP_LAST_NAME || EMP_FIRST_NAME AS FULL_NAME
	FROM
	(
		SELECT
		 EMP_CODE
		,REPLACE(EMP_LAST_NAME,' ','') EMP_LAST_NAME
		,REPLACE(EMP_FIRST_NAME,' ','') EMP_FIRST_NAME
		FROM EMP
		WHERE VALID_FLG = '1'
	)
	GROUP BY EMP_LAST_NAME,EMP_FIRST_NAME
	HAVING COUNT(EMP_CODE) > 1
) B
WHERE REPLACE(A.EMP_LAST_NAME,' ','') = B.EMP_LAST_NAME
AND REPLACE(A.EMP_FIRST_NAME,' ','') = B.EMP_FIRST_NAME
AND A.VALID_FLG = '1'
ORDER BY B.FULL_NAME,A.EMP_CODE