Delete Duplicate Records

How to delete duplicate records?

Showing Answers 1 - 12 of 12 Answers

Vyjayanthi

  • Mar 15th, 2016
 

Using row_number over partition by column

Prashanth

  • Jun 1st, 2016
 

1) Insert distinct data into temp table
2) Remove data from original table
3) Insert temp data into original table.

  Was this answer useful?  Yes

Raj Acharya

  • Sep 30th, 2016
 

Using CTE ...you can remove duplicate records in one query....

  Was this answer useful?  Yes

Naveen

  • Jun 16th, 2017
 

Insert the distinct rows from the duplicate rows table to new temporary table. Delete data from table which has duplicate rows then insert the distinct rows from the temporary table

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions