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)