SQL SUM () function

SqlSUM () function SUM () function

The sum () function returns the total number of numeric columns.

SQL SUM () syntax

SELECT SUM  from table_name;

Demo Database

In this tutorial, we will use the Runoob sample database.

The following is the data selected from the "Access_log" table:

Mysql> SELECT *  fromAccess_log;+-----+---------+-------+------------+|Aid|site_id| Count |Date|+-----+---------+-------+------------+|   1 |       1 |     $ |  .- to-Ten ||   2 |       3 |    - |  .- to- - ||   3 |       1 |    the |  .- to- - ||   4 |       2 |    Ten |  .- to- - ||   5 |       5 |   205 |  .- to- - ||   6 |       4 |     - |  .- to- the ||   7 |       3 |    - |  .- to- the ||   8 |       5 |   545 |  .- to- - ||   9 |       3 |   201 |  .- to- - |+-----+---------+-------+------------+9Rowsinch Set(0.00Sec

SQL SUM () instance

The following SQL statement finds the total number of "count" fields for the "Access_log" table:

Instance

SELECT SUM (count as from Access_log;

Execute the above SQL output as follows:

SQL SUM () function