-
SUM for multiple colums
Hello folks, I'm new here, I'm actually a Java guy who is doubling as a database programmer for now...
So...I have a table called Funds and columns are Q1, Q2, Q3, Q4, and funds_id (this is psuedo of course). So I need to get the total of all these, like I need to do this:
select (Q1 + Q2 + Q3 + Q4) as yearly_total
where funds_id = 'XXX'
something like that.
So how would I do that? Would I want to build a view? Thanks.
Edit: what I meant was, how would I use the SUM function, or could I just do it using the + symbol?
-
depends on what you want to do...
Code:
SQL> select * from xyz;
ID X Y Z
---------- ---------- ---------- ----------
1 1 2 3
2 4 3 2
3 10 11 12
10 1 2 7
SQL> select x+y+z from xyz where id=1;
X+Y+Z
----------
6
SQL> select x+y+z from xyz where id=3;
X+Y+Z
----------
33
SQL> select sum(x+y+z) from xyz where id in (1,3);
SUM(X+Y+Z)
----------
39
Jeff Hunter
-
Thanks alot, that was the answer I was looking for.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|