tralston/dupes.sql

Created December 19, 2018 20:09

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

Download ZIP

Finding Which dupes have at least one on each source, then showing the paths for all the dupes that qualify

Raw

	SELECT * from files
	WHERE hash IN (
	SELECT hash --, COUNT(source)
	FROM
	(SELECT *, COUNT(source) FROM files
	GROUP BY hash, source) AS A
	GROUP BY hash
	HAVING COUNT(source) > 1)

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