Total Values With SUM

Add numeric values across matching rows and return one aggregate total.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

Sum all order amounts

SUM(amount) collapses all remaining rows into one numeric total.

Source table data Rows loaded before the example query runs.

Setup

CREATE TABLE orders (id INT, amount INT);

INSERT INTO
  orders (id, amount)
VALUES
  (1, 40),
  (2, 35),
  (3, 25);

Validated query Shared across supported engines.

SQL

SELECT
  SUM(amount) AS total_amount
FROM
  orders;

Expected result Returned rows for the shared example.

total_amount
100

Validated across all four engines with identical aggregate output.

Useful when

Where this command helps.

totaling revenue or quantity across matching rows
rolling up line items into one numeric total

Explanation

What the command is doing.

SUM(column) adds the values in a numeric column across the rows that remain after filtering. It is one of the most common reporting functions for totals such as revenue, quantity, or hours.

Total Values With SUM

Sum all order amounts

Where this command helps.

What the command is doing.

Keep moving through nearby tasks.