SQL SUM() Function

SQL SUM() Syntax

The below syntax is used to make sum of a numeric value or numeric expression.

SELECT SUM(numeric_value or numeric expression);

The below syntax is used to make sum of a specific column from the specific table.

SELECT SUM(column_name or expression) FROM table_name;

Sample Database Table - Employee

SQL SUM() Example - With Single Column

The following SQL SELECT statement find the total salary of all employees from the "Employee" table:

SELECT SUM(Salary) As 'Total Salary' 
FROM Employee;

The result of above query is:

SQL SUM() Example - Using Expression Or Formula

The following SQL SELECT statement find the total salary, 20% bonus of salary, and then new total salary of all employees from the "Employee" table:

SELECT 
SUM(Salary) As 'Total Salary', 
SUM((Salary / 100) * 20) As 'Bonus 20%',  
SUM(Salary + ((Salary / 100) * 20)) As 'New Total Salary' 
FROM Employee;

The result of above query is:

SQL SUM() Example - Using Group By Clause

The following SQL SELECT statement find the total salary by grouping "Dept" column of all employees from the "Employee" table:

SELECT 
Dept, SUM(Salary) As 'Total Salary' 
FROM Employee 
GROUP BY Dept;

The result of above query is: