SQL: Selecting sum of two columns across multiple rows

Question

I have a table structure like this:

-------------------------------------
|  Country  |  Count 1  |  Count 2  |
-------------------------------------
|  USA      |  10       |  10       |
-------------------------------------
|  USA      |  10       |   10      |
-------------------------------------
|  France   |  200      |  200      |
-------------------------------------
|  USA      |  10       |  10       |
-------------------------------------
|  France   |  100      |  100      |
-------------------------------------

I would like to select the total of Count 1 and Count 2 for each country. So my output would be like

-------------------------
|  Country  |  Count    | 
-------------------------
|  USA      |    60     | 
-------------------------
|  France   |   600     |
-------------------------

How did you get the numbers in your output from the numbers in your sample input? — Michael McGriff
– Michael McGriff, Commented Jul 30, 2014 at 15:13
Where does the source table come from? Perhaps there's an unnecessary intermediate step here? — Strawberry
– Strawberry, Commented Jul 30, 2014 at 15:17
@Stromgren You'll get better assistance if you provide the correct output required based on the sample input instead of random numbers. — Michael McGriff
– Michael McGriff, Commented Jul 30, 2014 at 15:18

idmean · Accepted Answer · 2014-07-30 15:13:02Z

2

Try using SUM()

SELECT Country,
 SUM(`Count 1` + `Count 2`) AS count
FROM table_name 
GROUP BY country

answered Jul 30, 2014 at 15:13

idmean

15k9 gold badges63 silver badges90 bronze badges

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

Comments

Taryn · Accepted Answer · 2014-07-30 15:21:06Z

2

This is pretty straight-forward, you can use the aggregate function SUM() with a GROUP BY:

SELECT country, 
  sum(count1 + count2) as Total
FROM yourtable
GROUP BY country;

See Demo

edited Jul 30, 2014 at 15:21

answered Jul 30, 2014 at 15:13

Taryn

249k57 gold badges375 silver badges409 bronze badges

Comments

user2989408 · Accepted Answer · 2014-07-30 15:13:37Z

1

Try this

SELECT Country, SUM(Count_1 + Count_2)
FROM Table 
GROUP BY Country

answered Jul 30, 2014 at 15:13

user2989408

3,1371 gold badge20 silver badges15 bronze badges

Comments

Md khirul ashik · Accepted Answer · 2017-08-17 07:25:24Z

0

Try this.

UPDATE power 
  SET cnt = SUM(IFNULL(is_yellow, 0) + 
  IFNULL(is_green, 0) +  IFNULL(is_blue, 0));

answered Aug 17, 2017 at 7:25

Md khirul ashik

15310 bronze badges

Collectives™ on Stack Overflow

SQL: Selecting sum of two columns across multiple rows

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related