select EMP_CODE AS CODE,EMP_LAST_NAME AS SURNAME,EMP_FIRST_NAME AS NAME
FROM EMP
WHERE VALID_FLG = '1'
	AND REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME,' ','') IN 
		(SELECT REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME,' ','')
		 FROM EMP
		 WHERE VALID_FLG = '1'
		 GROUP BY
		 	REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME,' ','')
		 HAVING 
		 	COUNT(*)>1
		 )
ORDER BY replace((SURNAME || NAME),' ',''),CAST(CODE AS INTEGER)