title: Getting MIN Price in Subquery in SQL Server (using DISTINCT)?
body: <p>I am trying to get a Minimun price from a car in a table i have.. I am using DISTINCT</p>
  
  <p>SELECT DISTINCT </p>
  
  <p>datepart(year,[Registration]) AS YearRegistered,
  MIN(SalePrice), Model, Make</p>
  
  <p>FROM [VehicleSales] </p>
  
  <p>But its not working,  for example </p>
  
  <p>without distinct returns many car makes and models so i use distinct so i get unique cars that are the same make and model and year....</p>
  
  <p>I wish to incorporate a "Startign from price ..."  hence the SalePrice can also be different for same model and make ... so i want to do a MIN.. </p>
  
  <p>But i am bit confused, the above is working working...</p>
  
  <p>Any ideas?</p>