SQL

How to find duplicate rows in SQL Server

Richard Lewis
I ran into this problem the other day at work with duplicate rows while trying to merge data from two separate tables into the same table. I couldn’t remember so I just ran a quick search using Google and came across the solution on a Microsoft knowledge base page. col1 col2 1 1 2