problem in sum for two columns in the same table

Question

0.00/5 (No votes)

See more:

hiii all,
i have atable that contains (id, name, commission)
i need to have the sum of commission where name=a as'first' and the sum where name=b as 'second' in the same row , any help, please?????

thanks

Posted 13-Mar-11 22:52pm

moon2011

Add a Solution

Comments

OriginalGriff 14-Mar-11 4:55am

Sorry, that doesn't make a lot of sense.
Please edit your question and try to explain in better detail what you are trying to achieve.

Raj.rcr 14-Mar-11 4:58am

Can u please explain in detail ?

moon2011 14-Mar-11 5:16am

now i have atransaction (borrow and loan) i want to calculate the sum of loan for auser and the sum of borrower for the same user. all these data is in the same table, so i need arow tells me the accountId, Sum of Loan and the Sum of Borrower for him because i want to calculate the difference between them later.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raj.rcr · Accepted Answer · 2011-03-13T23:09:00

Solution 1

Its not possible to add the values of rows, u can add the values of a column instead..

SQL

select sum(commission)  as 'First' from table1 where name='a'
union
select sum(commission)  as 'Second' from table1 where name='b'

Posted 13-Mar-11 23:09pm

Raj.rcr

Comments

Dalek Dave 14-Mar-11 5:23am

Good Call.

moon2011 14-Mar-11 5:29am

thanks for your help, but the result was one column 'First' only, why it doesn't appear the second???

Raj.rcr 14-Mar-11 7:19am

I think, u may need the answer that costica has posted in the second solution.. Just a minor modification as in my code.. Follow the second solution..

moon2011 14-Mar-11 7:29am

thanks alot for help

Raj.rcr 14-Mar-11 7:32am

My pleasure..!

Costica U · Accepted Answer · 2011-03-14T01:00:00

Solution 2

Try this

SQL

select  [First] = (select sum(commission) from table1 where name='a'),
        [Second] = (select sum(commission) from table1 where name='b')

Posted 14-Mar-11 1:00am

Costica U

Comments

moon2011 14-Mar-11 7:29am

thanks

Costica U 14-Mar-11 7:37am

You are welcome!