games647/find-duplicates.sql

Last active August 26, 2016 11:51

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

Download ZIP

Find duplicates in SQL if COLUMN or COLUM, COLUM has the same values. Just replace TABLE and COLUMN with your setup.

Raw

find-duplicates.sql

	SELECT
	COLUMN, COUNT(*)
	FROM
	TABLE
	GROUP BY
	COLUMN
	HAVING
	COUNT(*) > 1

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