duplicate records

Question

how to eliminate duplicate records in sql server?

Suthish Nair · Answer

If the query got resolved then mark the post that helped you as Answer so will be helpful for others. Otherwise if you got the solution please share with us.

Lalit M · Answer

use below code sample DELETE FROM MyTable WHERE ID NOT IN ( SELECT MAX(ID) FROM MyTable GROUP BY DuplicateColumn1 DuplicateColumn2 DuplicateColumn3) OR SELECT DISTINCT * INTO DuplicateTb FROM dublicatetest GROUP BY snamerno HAVING COUNT(rno) > 1 will get more details below link http://www.kodyaz.com/articles/delete-duplicate-records-rows-in-a-table.aspx

Soft Corner · Answer

Hi Delete all the duplicates using CTE (Common table expression) and ROW_NUMBER() which is a new in SQL server 2005 and above. Refer this Article : - Remove Duplicate Records