How to sum values between multiple fields?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

rajendra prasad-377679 Mr or Mrs. 500 Points: 520 More actions · Answer 1

Mr or Mrs. 500

Points: 520

November 14, 2006 at 11:06 pm

select id,'total'=a+b+c,date from table_name

kpao SSC-Addicted Points: 406 More actions · Answer 2

It works but this is not a result I want. I think the query should use group by function.

ijaz SSCommitted Points: 1912 More actions · Answer 3

you are right.. for the correct result there should be a group by clause on the Id and Date.

Cheers

cheers

Sureshkumar Ramakrishnan Ten Centuries Points: 1200 More actions · Answer 4

The solution for such problems is obtained by using the aggreggate functions.

The required results can be obtainted by writing the query as below:

select id,total=sum(a+b,c) from table group by id

Kindest Regards,

Sureshkumar Ramakrishnan

binoj balan Newbie Points: 1 More actions · Answer 5

select id, sum (a) + sum(b)+ sum (c) as d from x group by id