jamesasu · August 18, 2020 00:08
diff --git a/bigquery-dedupe.sql b/bigquery-dedupe.sql
 -- Use window functions to remove duplicate rows:
 SELECT * EXCEPT(row_number)
 FROM (
  SELECT 
    Email,
    ROW_NUMBER() OVER (PARTITION BY Email) row_number
  FROM Dataset.Emails
 )
 WHERE row_number = 1
	-- Use window functions to remove duplicate rows:
	SELECT * EXCEPT(row_number)
	FROM (
	SELECT
	Email,
	ROW_NUMBER() OVER (PARTITION BY Email) row_number
	FROM Dataset.Emails
	)
	WHERE row_number = 1