codewithtyler/findingDuplicates.sql

Created August 13, 2020 16:15

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/codewithtyler/50f8c1df314e2fa9dc92081d8bac2bdf.js"></script>
Save codewithtyler/50f8c1df314e2fa9dc92081d8bac2bdf to your computer and use it in GitHub Desktop.

Download ZIP

Useful Oracle snippets

Raw

findingDuplicates.sql

	select column1, count( column2 )
	from table
	where column2 is not null
	having count ( column2 ) > 1
	group by column2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment