sql How to apply sum() with different condition in same column

Question

I want to get sum quantity of A and B in new column named group1 and group 2 have distinct value with Category . And want to get both columns in same execution .

c1   |   c2
---------------
A    |   2
B    |   1
A    |   2
B    |   1
A    |   2
B    |   1




result :


group1 | group2
---------------
A      | 6
B      | 3

I am trying this query but not working

 SELECT SUM(c2) WHERE DISTINCT c1 in('A','B') as 'group2' from table,
    SELECT DISTINCT c1 in('A','B') as 'group1' from table

Theo Babilon · Accepted Answer · 2015-12-06 08:42:20Z

2

Just a straightforward group by. Based on your example:

SELECT c1 as group1, SUM(c2) as group2 
FROM table
GROUP BY c1

edited Dec 6, 2015 at 8:42

Theo Babilon

6616 silver badges20 bronze badges

answered Dec 5, 2015 at 21:43

DBug

2,5661 gold badge14 silver badges26 bronze badges

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

2 Comments

phpnet Over a year ago

not working , I have tried with table reference also . Can you please put the query in complete syntax ?

DBug Over a year ago

Are you getting an error? In my example, replace "table" with the name of the table, like FROM mytable, where "mytable" is the name of your table

Collectives™ on Stack Overflow

sql How to apply sum() with different condition in same column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related