select 
	 E1.EMP_CODE CODE
	,E1.EMP_LAST_NAME SURNAME
	,E1.EMP_FIRST_NAME NAME
FROM
	EMP E1
WHERE
	EXISTS (
	    select 1
	    from emp E2
	    WHERE
	        E1.EMP_CODE <> E2.EMP_CODE and
	        REPLACE(E1.EMP_FIRST_NAME, ' ', '') = REPLACE(E2.EMP_FIRST_NAME, ' ', '') AND
	        REPLACE(E1.EMP_LAST_NAME, ' ', '') = REPLACE(E2.EMP_LAST_NAME, ' ', '') AND
	        E1.Valid_flg = '1' and E2.Valid_flg = '1'
	 )
ORDER BY
	REPLACE(EMP_LAST_NAME, ' ', '') || REPLACE(EMP_FIRST_NAME, ' ', '')
	,EMP_CODE ASC