SQL query for selecting sum of multiple column based on other column

Question

i have in database like this

say a table X with columns A and B

and i want to write sql query to get result in format

P Q
1 800
2 600

Where Q is sum of all having same value of A.

I thought of selecting the data in same format and then using the logic display it is there a way to do with SQL query?

Pramod Kumar · Accepted Answer · 2012-07-04 05:41:25Z

4

SELECT A as P, SUM(B) AS Q
FROM X
GROUP BY A

answered Jul 4, 2012 at 5:41

Pramod Kumar

8,0345 gold badges30 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andomar · Accepted Answer · 2012-07-04 05:36:19Z

4

select  A as P
,       sum(B) as Q
from    X
group by
        A

answered Jul 4, 2012 at 5:36

Andomar

239k55 gold badges387 silver badges412 bronze badges

Mahmoud Gamal · Accepted Answer · 2012-07-04 05:37:09Z

1

SELECT A AS P, SUM(B) AS Q
FROM TableA
GROUP BY A

answered Jul 4, 2012 at 5:37

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges