SQL Server query

Question

Hi friends I want to knowwhat is the query to delete the duplicate rows from the table?

Satyapriya Nayak · Answer

Hi Deepak 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 Thanks

Deepak Dwij · Answer

Perfect solution of my question. Thanks satyapriya nayak

Hemant Kumar · Answer

Hi Please refer this link http://blog.sqlauthority.com/2007/03/01/sql-server-delete-duplicate-records-rows/