dcs619 · August 11, 2016 16:10
diff --git a/removedupes.sql b/removedupes.sql
 WITH duplicates (name, address, city, state, id) 
 AS (
    SELECT name, address, city, state, ROW_NUMBER() OVER (
 	PARTITION BY name, address, city, state 
 	ORDER BY address desc
    ) AS id
    FROM source
 )
 DELETE FROM duplicates
 WHERE id > 1
	WITH duplicates (name, address, city, state, id)
	AS (
	SELECT name, address, city, state, ROW_NUMBER() OVER (
	PARTITION BY name, address, city, state
	ORDER BY address desc
	) AS id
	FROM source
	)
	DELETE FROM duplicates
	WHERE id > 1
No results found