SQL SUM

The SQL SUM() function is used to get the total of a column or an expression.

SQL SUM() Function Syntax

SELECT SUM(ColumnName)
FROM TableName
WHERE predicates

SQL SUM() Function Example

Table: Employees

Example 1
We want to know the total salary of all the employees:

SELECT SUM(Salary) AS TotalSalary
FROM Employees

The result will look like:

Example 2, using GROUP BY
We want to know total salary for each department:

SELECT Department, SUM(Salary) AS TotalSalary
FROM Employees
GROUP BY Department

The result will look like: