Skip to content

Instantly share code, notes, and snippets.

@mourawaldson

mourawaldson/duplicate_values.sql

Created April 28, 2012 19:54
Show Gist options
  • Save mourawaldson/1760a20404a2a619b42a to your computer and use it in GitHub Desktop.
Save mourawaldson/1760a20404a2a619b42a to your computer and use it in GitHub Desktop.
Download ZIP
Find duplicate values
Raw
duplicate_values.sql
SELECT `column`, 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