Delete Duplicate Records

How to delete duplicate records?

Showing Answers 1 - 4 of 4 Answers


  • Mar 15th, 2016

Using row_number over partition by column


  • 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 can remove duplicate records in one query....

  Was this answer useful?  Yes


  • 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