Delete duplicate row from the table
How can we delete duplicate row from the table through the SQL query ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Anil KumarPosted May 29, 2012, 9:05 AM
Refer: Removing Duplicates from a Table in SQL Server
Using JOIN, a good example can be found @
SQL Query to get rid of duplicate records
Satyapriya NayakPosted May 29, 2012, 7:01 AM
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
Posted May 29, 2012, 6:08 AM
ex: select distinct(empname) from employee