Skip to content

Instantly share code, notes, and snippets.

@thmsobrmlr

thmsobrmlr/find_duplicates.sql

Created July 10, 2013 17:06
Show Gist options
  • Save thmsobrmlr/5968105 to your computer and use it in GitHub Desktop.
Save thmsobrmlr/5968105 to your computer and use it in GitHub Desktop.
Download ZIP
Find duplicate rows in MySQL (having same value for a column). Replace 'column' and 'table' in statement with values specific to the case.
Raw
find_duplicates.sql
SELECT column, COUNT(*) count FROM table GROUP BY column HAVING count > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment