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 TableNameGroup by ColumnName Having (count(ColumnName) > 1)