How to Remove Duplicate Records from a Table

Hi Arun

There are many ideas to remove duplicate record from table

Idea 1:

http://blog.sqlauthority.com/2007/03/01/sql-server-delete-duplicate-records-rows/

Idea 2:
http://support.microsoft.com/kb/139444

Idea 3:
http://www.codeproject.com/Tips/159881/How-to-remove-duplicate-rows-in-SQL-Server-2008-wh

hope this will help you.

If your table is like below

ID     NAME
1       name1
2       name2
3       name1
4       name2
 
And you want to get rid of the duplicate data
you can try this.

BEGIN TRAN
DELETE
FROM T1
WHERE EXISTS(
SELECT * FROM T2
WHERE   
T1.NAME = T2.NAME  AND
T2.ID > T1.ID
)

SELECT * FROM

ROLLBACK

Hi Arun,


STEP 1 - Insert your distinct data into a temporary table select distinct* into temp from TableName
STEP 2 - Delete From TableName
STEP 3 - Insert TableName Select * From temp Write three step and remove duplicate values from your tables.


Thanks

Just recommend to refer:
Removing Duplicates from a Table in SQL Server