gistfile1.sql

DELETE FROM PROPERTY_MANAGER
WHERE PERSON_ID NOT IN (
	SELECT PERSON_ID 
	FROM(
		select *, 
		ROW_NUMBER() OVER 
			(
			partition by PROPERTY_ID 
			order by UPDATE_DATE desc
			) AS ROW_NUM
		from PROPERTY_MANAGER
	) foo
WHERE ROW_NUM = 1
);