dncpax/postgresql_find_duplicates.sql

Created May 24, 2019 15:32

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/dncpax/df64dd4fc67f1d846ba10e5a6d3ec335.js"></script>
Save dncpax/df64dd4fc67f1d846ba10e5a6d3ec335 to your computer and use it in GitHub Desktop.

Download ZIP

postgresql - find duplicates

Raw

postgresql_find_duplicates.sql

	select * from (
	SELECT id,
	ROW_NUMBER() OVER(PARTITION BY column1, column2 ORDER BY id asc) AS Row
	FROM tbl
	) dups
	where
	dups.Row > 1

Author

dncpax commented May 24, 2019 •

edited

Loading

Another possibility I like:

select objectid, count(*)
from table where condition=value
group by objectid
HAVING count(*) > 1

Simple to read and remember...

original here: https://stackoverflow.com/questions/50805439/postgresql-fastest-way-to-get-duplicates

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