Sum field1 and sum field2 then compare if field2>field1 etc

• bdelfini

  SSC Enthusiast

  Points: 186

  More actions

  March 16, 2009 at 8:50 am

  #207012

  sum(Case when answera = 2 then 1 else 0 end) as answera

  sum(Case when answerb = 2 then 1 else 0 end) as answerb

  from sometable

  I'd like to then compare answera with answerb in the statement

  and show

  if the sum of answerb is greater than answera

  or answera is = answerb

  or missing data from answera and answerb

  This is what I need to calculate

  # who had a score of 4 both times or improved by 1

  # in 3 months with both pieces of information

  # missing one or both assessment results

  thanks,

  how do I go about doing that?

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 16, 2009 at 12:19 pm

  #960508

  use a subquery like

  Select

  From

  (

  Select ...

  sum(Case when answera = 2 then 1 else 0 end) as answera

  sum(Case when answerb = 2 then 1 else 0 end) as answerb ) sq

  ....

  
  * Noel