#Netezza Deduplicate all data in table

netezza_dedupe.sql

delete from TEST_DATA c where exists 
	(select rowid from TEST_DATA a 
	left outer join(
		select min (rowid) as min_row, MSG_ID, MSG_ID2
		FROM TEST_DATA
		GROUP BY MSG_ID, MSG_ID2
		) x on a.rowid = x.min_row 
		where x.min_row is null and a.rowid = c.rowid);