Skip to content

Instantly share code, notes, and snippets.

@nastanford

nastanford/callDuplicates.sql

Created June 28, 2013 18:17
Show Gist options
  • Save nastanford/5886811 to your computer and use it in GitHub Desktop.
Save nastanford/5886811 to your computer and use it in GitHub Desktop.
Download ZIP
query an oracle to get duplicates.
Raw
callDuplicates.sql
select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment