Adnan Adnan - 10 months ago 71
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 Source

try this:

SELECT SUM(column) as total from table