Skip to content

Instantly share code, notes, and snippets.

@tobysteward
Created September 30, 2013 15:03
Show Gist options
  • Save tobysteward/6765113 to your computer and use it in GitHub Desktop.
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