kevgathuku/query.sql

Forked from hlashbrooke/query.sql

Last active August 29, 2015 14:08

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

Download ZIP

Raw

	SELECT email_address, COUNT(email_address) AS occurrences
	FROM users
	GROUP BY email_address
	HAVING occurrences > 1

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