Using group by with multiple fields

• pwalter83

  SSChampion

  Points: 14575

  More actions

  January 21, 2011 at 7:30 am

  #142184

  Hello,

  Could someone please tell if there was a way to use group by with one field when there are multiple fields in the select statement and at the same time also sum one of the fields(not rhe group by one) ?

  foe e.g. i need to achieve this:

  -----------------------------------

  Select BL_ID,

  sum(D.FRT_USD) as FRT_USD,

  TEU,

  SAISAN_MONTH

  from tablename

  group by BL_ID

  -----------------------------------

  Thanks,

  Paul

• LutzM

  SSC Guru

  Points: 107049

  More actions

  January 21, 2011 at 8:08 am

  #1276575

  Depending on your required output

  Select BL_ID,

  sum(D.FRT_USD) as FRT_USD,

  TEU,

  SAISAN_MONTH

  from tablename

  group by BL_ID,TEU,SAISAN_MONTH

  Or

  Select BL_ID,

  sum(D.FRT_USD) as FRT_USD,

  MIN(TEU) as Min_TEU,

  MIN(SAISAN_MONTH) AS Min_SAISAN_MONTH

  from tablename

  group by BL_ID

  Or there might be the need of a subquery. It depends.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]