matthisk/duplicates.sql

Created August 15, 2013 14:03

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

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

Download ZIP

Find duplicates in a table

Raw

duplicates.sql

	SELECT myColumn, count( myColumn ) AS myCount
	FROM myTable
	GROUP BY myColumn
	HAVING myCount >1
	ORDER BY myCount

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