Grouping data

• PaulSp

  SSCrazy

  Points: 2499

  More actions

  January 8, 2007 at 6:05 am

  #193832

  Hi

  I'm generally OK at grouping data, but am struggling with this.  Hopefully someone will have a simple answer.

  I want to find the lowest numbered ID from rows which have the same value.  A simplified version of the table data is shown below:

  ID Value

  123 900

  456 900

  665 400

  555 400

  111 200

  333 200

  I want the result to be as shown below:

  ID Value

  123 900

  555 400

  111 200

  Any ideas will be gratefully received.

  Thanks

  Paul

• David Burrows

  SSC Guru

  Points: 65143

  More actions

  January 8, 2007 at 6:30 am

  #681742

  SELECT MIN([ID]) AS [ID], Value

  FROM

  GROUP BY Value

  ORDER BY Value DESC

  Far away is close at hand in the images of elsewhere.
  Anon.

• PaulSp

  SSCrazy

  Points: 2499

  More actions

  January 8, 2007 at 7:12 am

  #681750

  Thanks, David

  I knew there was an easy solution here - I just couldn't see it.

  Thanks, again for your time.

  Paul