latompa/find duplicate records

Created October 30, 2009 02:29

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

Download ZIP

find duplicate records

Raw

find duplicate records

	SELECT name,
	COUNT(name)
	FROM users
	GROUP BY name
	HAVING ( COUNT(name) > 1 )

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