DELETE
FROM TableName
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM TableName
GROUP BY ColumnName)
How to Delete Duplicate Records from Table in SQL Server
This code snippet is for to delete duplicate records from table in sql server.
Loading
This code snippet is for to delete duplicate records from table in sql server.
DELETE
FROM TableName
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM TableName
GROUP BY ColumnName)