Delete Duplicate Row from Database Table in SQL Server

Hi Vipendra,

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

Please check this link:

http://www.simple-talk.com/sql/t-sql-programming/removing-duplicates-from-a-table-in-sql-server/