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

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)
Tags: