PostgreSQL SUM Function

SUM

The SUM() function returns the total sum of a numeric column.

The following SQL statement finds the sum of the quantity fields in the order_details table:

Example

Return the total amount of ordered items:

SELECT SUM(quantity)
FROM order_details;

Note: NULL values are ignored.

---

PostgreSQL Exercises

Test Yourself With Exercises

Exercise:

Use the correct function to return the total sum of all values of the field price in the products table.

SELECT FROM products;