Finding duplicates rows from a table in SQL Server.

Select Duplicate Rows:

SELECT col1, col2, count(*)

FROM t1

GROUP BY col1, col2

HAVING count(*) > 1