SQL SELECT SUM

By admin / December 13, 2018

SQL SELECT SUM : It is also known as SQL SUM() function. It is used in a SQL query to return summed value of an expression.

Let\’s see the Syntax for the select sum function:

SELECT SUM (expression)
FROM tables
WHERE conditions;

Example

SELECT SUM (salary) AS \"Total Salary\"
FROM employees
WHERE salary > 20000;