pikonha/duplicates.sql

Created February 24, 2021 20:49

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/pikonha/e063d1cad12d994acba496af934a1a3f.js"></script>
Save pikonha/e063d1cad12d994acba496af934a1a3f to your computer and use it in GitHub Desktop.

Download ZIP

[POSTGRES] Remove duplicates and left the first register

Raw

duplicates.sql

	with uniq as (
	select distinct on (table.a, table.b) *
	from table
	) delete from table table1 where table1.id not in (select id from uniq)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment