The SQL SUM() Function and How to Use It

Introducing the SQL SUM() Function

SQL SUM() is an aggregate function that allows you to get the sum of the selected numeric values.

Syntax for SUM() in SQL

To perform summation in SQL, we need to first select the values we need to add. To do that, we use the SELECT statement:

SELECT SUM(col_name)
FROM tbl_name
WHERE conditions;

In the syntax example above, you see three parameters:

• col_name defines the name of the column
• tbl_name defines the name of the table
• conditions defines specific conditions to filter particular values

Theory is great, but we recommend digging deeper!

How to Use & Set Up Microsoft SQL Server Database: SQL Server Training

Taurius Litvinavicius

5.0 (0)

Summation in SQL: an Example

To understand how to use SUM() in SQL better, we'll show you a simple example using a demo database.

A Demo Database

We will be using a part of the table called Orders:

Using SQL SUM()

In the code example below, we take the data records from the Price column in the Orders table and find out the total sum:

SELECT SUM(Price)
FROM Orders;