Count duplicate rows or records in Sql server

Introduction: In this article today I am going to explain how to count all duplicate rows/records in the table in Sql server

Description:

In the previous article I explained How to find the duplicate records in a tablein Sql server.

To count the duplicate records of each below run the below given query:

Select SudentName,Fee,StudentClass,StudentRollNo, count(*) as Duplicate from dbo.Student_Detail group by SudentName,Fee,StudentClass,StudentRollNo having count(*) >1