SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SUM over more than 1 column

683676Feb 6 2009 — edited Feb 9 2009

Hi,

I want to summate the values in more than 1 column. My code is like this

SELECT SUM(Column_A + Column_B) AS Column_C FROM TABLE GROUP BY ID

but this doesn't work.

I also tried

SELECT SUM(Column_A & Column_B) AS Column_C FROM TABLE

doesn't worked either ...

Any ideas?

Greetings from Germany
Lars

This post has been answered by isotope on Feb 6 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 9 2009

Added on Feb 6 2009

9 comments

1,245 views