How to find the duplicate rows in a table using sql script?

Submitted by admin on Tue, 05/04/2010 - 20:11

Posted in

Here is the SQL Script to find the duplicate rows in a table in SQL Server

This Script will give you the count of the number of the times the records are repeated in the column.

select ColumnName, count(ColumnName) as MoreThan1 from TableName

Group by ColumnName Having (count(ColumnName) > 1)

Add new comment