Skip to content

Instantly share code, notes, and snippets.

@kevgathuku
Forked from hlashbrooke/query.sql
Last active August 29, 2015 14:08
Show Gist options
  • Save kevgathuku/0e1859dcde2eb337289c to your computer and use it in GitHub Desktop.
Save kevgathuku/0e1859dcde2eb337289c to your computer and use it in GitHub Desktop.
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