Jammink2/find_duplicate_emails.sql

Created September 16, 2016 00:22

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Jammink2/ba5ab85da368fc65fc33e910a63dbd0d.js"></script>
Save Jammink2/ba5ab85da368fc65fc33e910a63dbd0d to your computer and use it in GitHub Desktop.

Download ZIP

Raw

find_duplicate_emails.sql

SELECT email FROM <tbl_name> GROUP BY email HAVING COUNT(1) > 1 -- to find duplicate emails

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