SQL Query Help

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  February 15, 2008 at 1:58 pm

  #154136

  Can anyone help me build a sql for teh below scenario

  id score

  1 100

  2 200

  3 300

  4 500

  I need a output as Total scrore scoremorethan200

  1100 800

  the above being 2 columns as output one with total score and another having total count of score >200 any help on this will be greatly appreciated. TIA

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  February 15, 2008 at 3:59 pm

  #779036

  select sum(score) as TotalScore

  , sum( case when score > 200 then score else null end )

  as GT200TotalScore

  from ....

  SQL = Scarcely Qualifies as a Language