Adding two values in mysql

Question

I have a table like this:

A      B        C         Value
1990    1   1   0.791684449
1990    1   2   0.058315583
1990    2   3   2.940000057
1990    3   4   8.975000381
1990    4   5   0
1990    4   6   0.004666695
1990    4   7   0.401333332
1990    5   8   2.609000206
1990    6   9   6.400992393
1990    6   10  9.489910126
1990    6   11  1.31809783
1990    7   12  214.4270172
1990    8   13  0.097975887
1990    8   14  0.680250943
1990    8   15  9.270773888
1990    9   16  1.204782724
1990    9   17  4.113919258
1990    9   18  3.486953974
1990    9   19  1.675345063
1990    10  20  0.434966862
1990    10  21  2.561163187
1990    10  22  2.415041685
1990    10  23  2.660344124
1990    10  24  7.127485275

Now I want to add only those values whose B is same & display in a table according to the C like:

1990        1   0.850000031
1990        2   2.940000057
1990        3   8.975000381
1990        4   0.406000027
1990        5   2.609000206
1990        6   17.20900035

How can I do this in MySQL?

Mark Byers · Accepted Answer · 2012-10-23 08:09:12Z

3

Use GROUP BY and SUM.

Try this SQL:

SELECT A, B, SUM(Value) AS TotalValue
FROM yourtable
GROUP BY A, B

See it working online: sqlfiddle

See the documentation for more details:

GROUP BY (Aggregate) Functions

answered Oct 23, 2012 at 8:09

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

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

1 Comment

Rashid Over a year ago

Thanks Mark! I got my solution.

John Woo · Accepted Answer · 2012-10-23 08:14:39Z

2

Use AGGREGATE FUNCTION SUM() to calculate the total values and grouped them by A and B

SELECT A, B, SUM(c) totalValue
FROM tableName
GROUP BY A, B

SQLFiddle Demo

edited Oct 23, 2012 at 8:14

answered Oct 23, 2012 at 8:09

John Woo

265k70 gold badges509 silver badges500 bronze badges

1 Comment

John Woo Over a year ago

you're welcome @Rashid. please take time to read the link above :D

Val · Accepted Answer · 2012-10-23 08:10:18Z

0

select A,B, sum(value) from table group by B,A

answered Oct 23, 2012 at 8:10

Val

4134 silver badges11 bronze badges

Comments

Alessandro Minoccheri · Accepted Answer · 2012-10-23 08:35:14Z

0

Try this:

SELECT A, min(c) c,SUM(value) totalValue
FROM tableName
GROUP BY A, B

edited Oct 23, 2012 at 8:35

Alessandro Minoccheri

36.1k22 gold badges128 silver badges176 bronze badges

answered Oct 23, 2012 at 8:18

AnandPhadke

13.5k5 gold badges28 silver badges34 bronze badges

Collectives™ on Stack Overflow

Adding two values in mysql

4 Answers 4

1 Comment

SQLFiddle Demo

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related