Learn From - Interactive SQL


Next Chapter »

SQL SUM() Function


SUM() function adds all the values of the specified numeric column on which it is used.

SQL SUM() Syntax


SELECT SUM(column_name)
FROM table_name

Below is shown the "Orders" table:

OrderID CustomerID Date Amount
D001 C001 4/3/2007 12:00:00 AM 150.23
D002 C003 1/22/2005 12:00:00 AM 123.57
D003 C005 3/19/2003 12:00:00 AM 220.43
D004 C007 7/21/2008 12:00:00 AM 157.72
D005 C008 2/28/2009 12:00:00 AM 223.78
D006 C011 3/21/2005 12:00:00 AM 245.34

SQL SUM() Example


Text Editor below has the SQL Query, click the "View Result" button, to see the result.

To add all the values of the Amount column in the Orders table.

Select SUM(Amount) as TotalAmount from Orders;

SQL in Text Editor:








Next Chapter »