CODE SNIPPETS

All the Code Snippets and Samples you need

Microsoft SQL Server

How to delete duplicate records using MSSQL

ByAdministrator

Feb 18, 2015 , , , , , , , , , , , , , , , , , , , , , , ,

To delete duplicate records using MSSQL you can use the following snippet.
The table must have identity column, which will be used to identify the duplicate records.

DELETE
FROM TableName
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM TableName
GROUP BY ColumnWithDuplicatesName)

By Administrator

Related Post

Microsoft SQL Server

How to get the current Database and Log Filesize using MSSQL

May 22, 2015 Administrator
Microsoft SQL Server

How to drop Primary Key of a Table using MSSQL

Apr 21, 2015 Administrator
Microsoft SQL Server

How to search stored procedures using MS-SQL

Apr 15, 2015 Administrator
6 thought on “How to delete duplicate records using MSSQL”

Leave a Reply