Did you find this useful?
Socialize it today.

SQL SUM Function

Saturday, December 10, 2011

tags SQL

The SQL SUM function returns the sum of the selected column, containing numeric values.

Employees Table

1000John Smith40
1001Fred White27
1002Jane Scott53
1003Samuel Williams31

In this example, we want to find the sum of all the employees' ages in the employees table.


SELECT SUM(column_name)
FROM Table

SELECT SUM(age) as [Sum of Ages]
FROM employees


Sum of Ages

The SQL SUM function is used to find the sum of the numeric values in a given column.

Please help us spread the word by socializing it today!

email contact us

Did you find something wrong with the information on this page? Please take a moment to report it to us so that we can continue to improve the quality of the information on this site. Click here to report an issue with this page.

Recommended Books & Training Resources

SQL Cookbook Head First SQL: Your Brain on SQL A Learners Guide