Skip to content

Instantly share code, notes, and snippets.

@telingadigital

telingadigital/finding_duplicate.sql

Created April 11, 2018 05:59
Show Gist options
  • Save telingadigital/d38c085fdd064b739ab2bd683a7b5a25 to your computer and use it in GitHub Desktop.
Save telingadigital/d38c085fdd064b739ab2bd683a7b5a25 to your computer and use it in GitHub Desktop.
Download ZIP
Finding Duplicate Values in MySQL
Raw
finding_duplicate.sql
SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment