How to find the duplicate rows in a table using sql script?
Posted by admin on Wednesday, 13 November 2013
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)