How to delete the Duplicate Records in SQL?

Question

Upendra Pratap Shahi · Answer

WITH CTE AS ( SELECT [col1]  [col2]  [col3]  [col4]  [col5]  [col6]  [col7]  RN = ROW_NUMBER () OVER ( PARTITION BY col1 ORDER BY col1 ) FROM dbo . Table1 ) DELETE FROM CTE WHERE RN > 1 use below link- http://sqlfiddle.com/#!6/fae73/1/0 http://www.codeproject.com/Articles/157977/Remove-Duplicate-Rows-from-a-Table-in-SQL-Server

Rajeesh Menoth · Answer

Hi Ref the following article: 1) http://stackoverflow.com/questions/18390574/how-to-delete-duplicate-rows-in-sql-server 2) http://www.codeproject.com/Articles/157977/Remove-Duplicate-Rows-from-a-Table-in-SQL-Server

Pankaj Kumar Choudhary · Answer

hello @Kinngs you can read my this article you will find various way to delete the duplicate records http://www.c-sharpcorner.com/UploadFile/f0b2ed/handling-duplication-in-sql/

Rohan Gupta · Answer

Hi dhinesh please use below query DELETE FROM Customers WHERE ID NOT IN (SELECT min(ID) FROM Customers GROUP BY FirstName LastName)