L3V147H4N/sql_find_duplicates

Created March 18, 2015 17:26

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

Download ZIP

SQL - Find Duplicates By Given Field

Raw

sql_find_duplicates

	SELECT *
	FROM Table
	WHERE Table.Field IN (
	SELECT Table.Field
	FROM Table
	GROUP BY Table.Field
	HAVING COUNT(*) > 1
	)
	ORDER BY Table.Field

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