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.

Raj Acharya

• Sep 30th, 2016

 

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

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