Sunday, 18 January 2015

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

No comments: