SQL sum all values in column

Question

I have table with 500+ rows and I want to sum all the values in a column.

Example:

 name  | number
 ----------------
 name1 | 25
 name2 | 10
 name3 | 5
 name4 | 20

The total sum is: 60

I can do that via PHP but is this possible using an SQL query?

Does this answer your question? SQL- Add up Values in a Column — Nigel Ren
– Nigel Ren, Commented Oct 28, 2020 at 8:44

GMB · Accepted Answer · 2020-10-28 00:06:48Z

5

Just sum():

select sum(number) as total_number
from mytable

answered Oct 28, 2020 at 0:06

GMB

224k25 gold badges103 silver badges151 bronze badges

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

1 Comment

i dont know why i actualy didint think about this 🤦‍♂️