How to add up the numbers in a column?

Question

id  |  number
1   |    10
2   |    24
3   |    45
4   |    25
5   |    12

How can I get the sum of all numbers in the number column? Thanks

Dan J · Accepted Answer · 2011-04-21 17:14:51Z

7

SELECT SUM(number) FROM table

Should do it.

If you only want to sum some of the numbers, or aggregate them by groups of IDs, or some other thing, then you'll need to learn about WHERE or GROUP BY clauses. :)

answered Apr 21, 2011 at 17:14

Dan J

16.8k7 gold badges53 silver badges82 bronze badges

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

Comments

Yamikuronue · Accepted Answer · 2011-04-21 17:15:21Z

1

Should just be SELECT SUM(number) FROM table.

http://www.tizag.com/mysqlTutorial/mysqlsum.php has a nifty tutorial

answered Apr 21, 2011 at 17:15

Yamikuronue

7581 gold badge11 silver badges37 bronze badges

Comments

Marc B · Accepted Answer · 2011-04-21 17:15:17Z

0

select sum(number)
from yourtable

You'll want to look at MySQL's aggregate functions to see what all's available.

answered Apr 21, 2011 at 17:15

Marc B

362k44 gold badges433 silver badges508 bronze badges

Comments

daniel11 · Accepted Answer · 2011-09-23 10:53:06Z

0

SELECT SUM(number) from table ...

try the code above.

edited Sep 23, 2011 at 10:53

daniel11

2,04110 gold badges39 silver badges46 bronze badges

answered Apr 21, 2011 at 17:14

Naftali

147k41 gold badges247 silver badges304 bronze badges

Collectives™ on Stack Overflow

How to add up the numbers in a column?

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