SQL Question

• Noc234234

  Old Hand

  Points: 335

  More actions

  July 17, 2009 at 7:44 am

  #97842

  I need to display results that are distinct on one column and can choose any result ( the max preferred ) from another column. Here's the example table:

  Letter Number

  A 1

  A 2

  A 4

  B 3

  B 7

  B 9

  I need to display :

  A 4

  B 9

  Bascially I want to use DISTINCT, but only on one column while still displaying a 2nd column.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 17, 2009 at 7:45 am

  #1026181

  Are you familiar with Max() and Group By?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon