In SQL Server, the SUM()
aggregate function returns the sum of a given expression.
It can also be used to return the sum of all distinct (unique) values in the expression.
SUM()
only works on numeric columns. Null values are ignored.
In SQL Server, the SUM()
aggregate function returns the sum of a given expression.
It can also be used to return the sum of all distinct (unique) values in the expression.
SUM()
only works on numeric columns. Null values are ignored.
Below is a full list of mathematical functions available in PostgreSQL.
These are arranged into the following four categories:
In PostgreSQL, atanh()
is a hyperbolic function that returns the inverse hyperbolic tangent of its argument.
The argument and return value are provided as a double precision value.
Continue readingIn PostgreSQL, acosh()
is a hyperbolic function that returns the inverse hyperbolic cosine of its argument.
The argument and return value are provided as a double precision value.
Continue readingIn PostgreSQL, asinh()
is a hyperbolic function that returns the inverse hyperbolic sine of its argument.
The argument and return value are provided as a double precision value.
Continue readingIn PostgreSQL, cosh()
is a hyperbolic function that returns the hyperbolic cosine of its argument.
The argument and return value are provided as a double precision value.
Continue readingIn PostgreSQL, tanh()
is a hyperbolic function that returns the hyperbolic tangent of its argument.
The argument and return value are provided as a double precision value.
Continue readingIn PostgreSQL, sinh()
is a hyperbolic function that returns the hyperbolic sine of its argument.
The argument and return value are provided as a double precision value.
Continue readingIn PostgreSQL, mod()
is a mathematical function that returns the remainder from division of the first argument (the dividend) by the second argument (the divisor).
In PostgreSQL, width_bucket()
is a mathematical function that assigns values to buckets (individual segments) in an equiwidth histogram.
The return type is int.
Continue reading