Sum newfield (variable) from select statement

[james0816]

I know this can be done but unfortunately, I cannot remember how to code it.

If i have the following select statement

select a, b, c, (case when a = 2 then a else b + c) as newfield

from testtbl

where a <9

this will result in quite a few records. What I want to do is a sum statement to get the sum of newfield.

can someone assist?

thx

 

[r937]

select sum(newfield) as total_newfield
  from (
       select a
            , b
            , c
            , case when a = 2 
                   then a 
                   else b + c end ) as newfield
         from testtbl
        where a < 9
        ) as mydata

r937.com | rudy.ca