Returning Lowest Value From Table

• dallibabs

  Say Hey Kid

  Points: 706

  More actions

  March 26, 2012 at 3:54 am

  #255384

  Hi this is my first time posting so Hope it is in the correct area.

  I have a table example below.

  Model Number, Price

  model1 , 10

  model1 , 15

  model2 , 20

  model2 , 25

  I would like to return the lowest value based on the price field. so results would look like.

  Model Number, Price

  model1 , 10

  model2 , 20

  I think I used select distinct in the past but cant seem to get it working.

  Can anyone suggest a way of doing this I had this working in the past but lost my db. and I havnt used sql for a looong time.

  Thanks for you help.

  John/.

• Mark Cowne

  One Orange Chip

  Points: 26944

  More actions

  March 26, 2012 at 4:17 am

  #1464141

  Just a GROUP BY should do it

  SELECT [Model Number], MIN(Price) AS Price

  FROM myTable

  GROUP BY [Model Number]

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537

• dallibabs

  Say Hey Kid

  Points: 706

  More actions

  March 26, 2012 at 4:27 am

  #1464145

  Hi Mark that worked just as I wanted.

  Thanks very much for your speedy reply.:-)

  John.