How to delete duplicate rows in SQL Server? Ask Question 334. This query will delete non-duplicate records. – Derek Smalls Nov 30 '17 at 16:01. This works fine, thank you. @DerekSmalls this not remove my non-duplicate records. – monteirobrena Dec 7 '17 at 13:08.Sql Exclude DuplicatesSql Exclude DuplicatesIntroductionOften we come across situations where duplicate rows exist in a table, and a nee..