Skip to content

Instantly share code, notes, and snippets.

@tobysteward
Created September 30, 2013 15:03
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save tobysteward/6765113 to your computer and use it in GitHub Desktop.
Look for duplicates
select columnName,count(columnName) from tableName
group by columnName having count(columnName) > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment