array_agg
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT array_agg(column1) AS value FROM tbl; -- value '[1, 5, 9]'
function array_agg($1) returns array<$1>
avg
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT avg(tbl.column1) AS value FROM tbl; -- value '5.0'
function avg(double) returns double function avg(decimal(p, s)) returns decimal(p, s) function avg(real) returns real
count
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT count(tbl.column1) AS value FROM tbl; -- value '3'
function count() returns bigint function count($1) returns bigint
max
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT max(tbl.column1) AS value FROM tbl; -- value '9'
function max($1, ...) returns $1
min
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT min(tbl.column1) AS value FROM tbl; -- value '1'
function min($1, ...) returns $1
stddev
function stddev(bigint) returns double function stddev(double) returns double
stddev_pop
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT stddev_pop(column1) as value from tbl; -- value '3.265986323710904'
function stddev_pop(bigint) returns double function stddev_pop(double) returns double
stddev_samp
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT stddev_samp(column1) as value from tbl; -- value '4.0'
function stddev_samp(bigint) returns double function stddev_samp(double) returns double
sum
CREATE TABLE tbl AS VALUES (1), (5), (9); SELECT sum(tbl.column1) AS value FROM tbl; -- value '15'
function sum(bigint) returns bigint function sum(double) returns double function sum(decimal(p, s)) returns decimal(38, s) function sum(real) returns real