#delete duplicate records in sql

[amirazam]

Sometimes we required to delete duplicate records in sql from a table although the table has a UniqueID Column with identity. In this article, I would like to share the best way to delete duplicate rows in SQL server from a table.

Suppose we have below Employee table in SQL Server.

CREATE TABLE dbo.Employee ( EmpID int IDENTITY(1,1) NOT NULL, Name varchar(55) NULL, Salary decimal(10, 2) NULL, Designation varchar(20) NULL)