Join Help

• mschultze

  SSC Journeyman

  Points: 80

  More actions

  January 6, 2004 at 1:32 pm

  #107342

  Hi,

  I've seen something like this here before and have been unable to dig it up.

  I need to be able to do the following to cull down duplicates in F1 to a single row that has the minimum value of F2.  F1 and F2 are varchars

  F1,F2

  A,A

  A,B

  A,C

  B,1

  B,2

  B,3

  Result needs to look like

  F1,F2

  A,A

  B,1

  This site has been a great help!

  -Mike

   

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 6, 2004 at 1:39 pm

  #488863

  SELECT F1, MIN(F2)

  FROM TBL

  GROUP BY F1

  

  
  * Noel

• mschultze

  SSC Journeyman

  Points: 80

  More actions

  January 6, 2004 at 1:53 pm

  #488864

  Well that was easy - I'm smiling again - Thanks!