How to find duplicate rows in SQL Server

June 10, 2008    SQL

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