SQL SUM() Function
SQL SUM() function returns the total sum of all values of a numeric column in a table. You can use SUM function with number values only and also NULL values are ignored during addition.
We will consider couple of examples from table tblNewStudents.
Let’s take sum of Fees column from tblNewStudents table.
SELECT SUM(Fees) AS FEES FROM tblNewStudents
You can also filter the output with WHERE clause as given below.
SELECT SUM(Fees) AS FEES FROM tblNewStudents WHERE Fees >= 25000
Here, we have calculated sum of fees greater than or equal to 25000 from tblNewStudents table.
Reference: Manzoor Siddiqui [www.SQLServerLog.com]