Skip to content

Instantly share code, notes, and snippets.

@kevinsearle

kevinsearle/dupe-check.sql

Created May 22, 2018 19:23
Show Gist options
  • Save kevinsearle/0a421f2ce4a705f90d79e7518c434073 to your computer and use it in GitHub Desktop.
Save kevinsearle/0a421f2ce4a705f90d79e7518c434073 to your computer and use it in GitHub Desktop.
Download ZIP
SQL dupe check
Raw
dupe-check.sql
SELECT MY_COLUMN, COUNT(*) AS `count` FROM MY_TABLE GROUP BY MY_COLUMN HAVING `count` > 1 ORDER BY `count` DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment