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:


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



Post a Comment

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget