Sum

Aggregate Function

Description

Sum of expression across all input values.

Click here to navigate to the PostgreSQL docs page for this syntax.

The function Sum() is supported on Snowflake.

Grammar Syntax

SUM(expression)

Sample Source Patterns

PostgreSQL

Code

CREATE OR REPLACE TABLE ranks (
	rank int NOT NULL
);

INSERT INTO ranks
VALUES (6), (5), (8);

SELECT
   SUM(rank)
FROM
   ranks;

Result

19

Snowflake

Code

CREATE OR REPLACE TABLE ranks (
	rank int NOT NULL
);

INSERT INTO ranks
VALUES (6), (5), (8);

SELECT
   SUM(rank)
FROM
   ranks;

Result

19