In this article i will explain how to find or count duplicate record in SQL Server.
In this example i have a datatable and this table doesn't contain any primary key because of that duplicate records inserted in table.
First i will create table without contain any primary key
CREATE TABLE [dbo].[Emp_Info]
[Emp_Id] [int] NULL,
[Name] [varchar](50) NULL,
[Salary] [int] NULL,
[City] [varchar](50) NULL
)Now insert some duplicate record in this table.
Now count how many duplicate record exits in datatable with the help of below query
select Emp_Id, Name, Count(*) as DuplicateRecord
Group By Emp_Id, Name, City
Having Count(*) >1 Order By Emp_Id