CodingFusion

How to delete duplicate records in MSSQL Server?

 Here I have assumed that table name is Cars and Carid is primary key.

 

DELETE FROM CARS WHERE carId NOT IN (select MAX(carId)AS carId from Cars group by Model)
 
You might also like:
1)  C# Program to Check Whether a Number is Positive or Negative
2)  HTML.HiddenFor set value in Asp.Net MVC
3)  C# Program to Calculate the Area of a Square
4)  How to Get HttpRequestMessage Data in .NET MVC
5)  Different Ways to Get the Current User in ASP.NET MVC
About Us | Terms of Use | Privacy Policy | Disclaimer | Contact Us Copyright © 2012-2024 CodingFusion
50+ C# Programs for beginners to practice