Query Help

• doung zhang

  SSC Rookie

  Points: 28

  More actions

  October 8, 2004 at 11:33 am

  #63447

  Hi there,

   

  I have subtotal1, subtotal2 columns in my table Test, I would like to sum(subtotal1) and sum(subtotal2) into one total based on the condition, if subtotal2=0 then sum(subtotal1) as total, if else then sum(subtotal2) as total, but all the sum need to return one total.

   

  Please give me some direction?

   

  Thanks

  Don

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  October 8, 2004 at 12:23 pm

  #526009

  select sum( case when sub2 = 0 then sub1 else sub2 end)

  from ...