Remove Duplicates

Submitted by: 
Most of the time, we encounter duplicate records in our database. And it's not easy to delete it if you don't have enough knowledge about SQL Statement. This code will help you detect and delete duplicate records in SQL Server 2005 and above. (These commands only works on sql server 2005 or higher) Create table CREATE TABLE example ( id INT IDENTITY ( 1 , 1 ) , name VARCHAR ( 20 ) , class VARCHAR...