Adnan Adnan - 13 days ago 5
MySQL Question

sql How to Count numbers

I want count numbers from column in table in database

This example:

enter image description here

39 + 23 + 9 = 71
How I can Do that?

mysql code:

SELECT COUNT(column) as total from table


but it not working

Thanks in advance

BWS BWS
Answer

try this:

SELECT SUM(column) as total from table