-
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?
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
|