Aggregate Functions

`array_agg`

Returns an array created from the input x elements. Examples:

examples.sql

CREATE TABLE tbl AS VALUES (1), (5), (9);  SELECT array_agg(column1) AS value FROM tbl;
 -- value '[1, 5, 9]'

Supported Signatures

function array_agg($1) returns array<$1>

🔗 Official Documentation

`avg`

Returns the average (arithmetic mean) of all input values. Examples:

examples.sql

CREATE TABLE tbl AS VALUES (1), (5), (9); 
 SELECT avg(tbl.column1) AS value FROM tbl; -- value '5.0'

Supported Signatures

function avg(double) returns double
function avg(decimal(p, s)) returns decimal(p, s)
function avg(real) returns real

🔗 Official Documentation

`count`

Returns the number of input rows. Examples:

examples.sql

CREATE TABLE tbl AS VALUES (1), (5), (9); 
 SELECT count(tbl.column1) AS value FROM tbl; -- value '3'

Supported Signatures

function count() returns bigint
function count($1) returns bigint

🔗 Official Documentation

`max`

Returns the maximum value of all input values. Examples:

examples.sql

CREATE TABLE tbl AS VALUES (1), (5), (9); 
 SELECT max(tbl.column1) AS value FROM tbl; -- value '9'

Supported Signatures

function max($1, ...) returns $1

🔗 Official Documentation

`min`

Returns the minimum value of all input values. Examples:

examples.sql

CREATE TABLE tbl AS VALUES (1), (5), (9); 
 SELECT min(tbl.column1) AS value FROM tbl; -- value '1'

Supported Signatures

function min($1, ...) returns $1

🔗 Official Documentation

`stddev`

This is an alias for stddev_samp(). Supported Signatures

function stddev(bigint) returns double
function stddev(double) returns double

🔗 Official Documentation

`stddev_pop`

Returns the population standard deviation of all input values. Examples:

examples.sql

CREATE TABLE tbl AS VALUES (1), (5), (9);  SELECT stddev_pop(column1) as value from tbl;
 -- value '3.265986323710904'

Supported Signatures

function stddev_pop(bigint) returns double
function stddev_pop(double) returns double

🔗 Official Documentation

`stddev_samp`

Returns the sample standard deviation of all input values. Examples:

examples.sql

CREATE TABLE tbl AS VALUES (1), (5), (9);  SELECT stddev_samp(column1) as value from tbl;
 -- value '4.0'

Supported Signatures

function stddev_samp(bigint) returns double
function stddev_samp(double) returns double

🔗 Official Documentation

`sum`

Returns the sum of all input values. Examples:

examples.sql

CREATE TABLE tbl AS VALUES (1), (5), (9); 
 SELECT sum(tbl.column1) AS value FROM tbl; -- value '15'

Supported Signatures

function sum(bigint) returns bigint
function sum(double) returns double
function sum(decimal(p, s)) returns decimal(38, s)
function sum(real) returns real

🔗 Official Documentation

SDF DB

Trino Supported Functions

Aggregate Functions

`array_agg`

`avg`

`count`

`max`

`min`

`stddev`

`stddev_pop`

`stddev_samp`

`sum`

​array_agg

​avg

​count

​max

​min

​stddev

​stddev_pop

​stddev_samp

​sum

`array_agg`

`avg`

`count`

`max`

`min`

`stddev`

`stddev_pop`

`stddev_samp`

`sum`