rpuglielli/duplicatedData.txt

Last active August 14, 2018 02:14

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

Download ZIP

SQL to find duplicated rows

Raw

duplicatedData.txt

	SELECT field, Count(*)
	FROM table_name
	GROUP BY field
	HAVING Count(*) > 1

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