Sum of Column When Values Different

• AMCiti

  SSC-Addicted

  Points: 485

  More actions

  February 24, 2020 at 6:37 pm

  Go to Answer

  #3728358

  Dear Forum:

  I have a Column1 that has values from 1 - 9.  I need to Sum the values of this column for each value (1 through 9) when Column2 = '1'

  So I the results would be:

  1 = 23

  2 = 43

  3 = 96

  .....

  Would appreciate some help on how to accomplish this.

• Michael L John

  One Orange Chip

  Points: 26551

  More actions

  February 24, 2020 at 6:44 pm

  Answer

  #3728360

  SELECT 
  
   SUM(CASE WHEN COLUUMN1 = 1 THE COLUMN1 ELSE 0 END),
  
   SUM(CASE WHEN COLUUMN1 = 2 THE COLUMN1 ELSE 0 END),
  
  And so forth
  
  FROM YourTable
  
  WHERE Column2 = 1

   

  • This reply was modified 4 years, 7 months ago by  Michael L John.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/

• ScottPletcher

  SSC Guru

  Points: 100262

  More actions

  February 24, 2020 at 7:32 pm

  #3728373

   

  SELECT Column1, COUNT(*) * Column1 AS SumColumn1
  FROM dbo.table_name
  WHERE Column2 = '1'
  GROUP BY Column1
  ORDER BY Column1
  
  

  SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!