SQL - Find Duplicate Data Column Values

Here is a quick snippet on how to find duplicate columns within your tables

Code Snippet

1. select col1, col2, count(*)
2. from TABLE
3. group by col1, col2
4. having count(*) > 1

End of Code Snippet