Delete Duplicate Row from Database Table in SQL Server

Question

Hi friends I want to know how to delete duplicate row from database table in SQL Server ? Thank you.

Satyapriya Nayak · Answer

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

Vulpes · Answer

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