zuzannamj · November 20, 2020 09:39
diff --git a/deduplicate_subscribers.sql b/deduplicate_subscribers.sql
 SELECT contact.Email,
 contact.Id
 FROM /*data extension name*/ contact
 INNER JOIN (
    SELECT Email,
    MAX(Id) AS Id
    FROM /*data extension name*/
    GROUP BY Email
 ) aggr
 ON aggr.Email = contact.Email AND aggr.Id = contact.Id
	SELECT contact.Email,
	contact.Id
	FROM /data extension name/ contact
	INNER JOIN (
	SELECT Email,
	MAX(Id) AS Id
	FROM /data extension name/
	GROUP BY Email
	) aggr
	ON aggr.Email = contact.Email AND aggr.Id = contact.Id