The SQLite json_group_array() function is an aggregate function that returns a JSON array comprised of all values in the aggregation.
In other words, it constructs an array from the values provided by its argument.
Continue readingTag: aggregate functions
SUM() Function in PostgreSQL
In PostgreSQL, the SUM() function computes the sum of the non-null input values and returns the result.
In other words, it adds numbers and returns the result.
Continue readingAVG() Function in PostgreSQL
In PostgreSQL, the AVG() function computes the average (arithmetic mean) of all the non-null input values, and returns the result.
MAX() Function in PostgreSQL
In PostgreSQL, the MAX() function computes the maximum of the non-null input values and returns the result.
This function can be used on any numeric, string, date/time, or enum type, as well as inet, interval, money, oid, pg_lsn, tid, and arrays of any of these types.
MIN() Function in PostgreSQL
In PostgreSQL, the MIN() function computes the minimum of the non-null input values and returns the result.
This function can be used on any numeric, string, date/time, or enum type, as well as inet, interval, money, oid, pg_lsn, tid, and arrays of any of these types.
SUM() Function in MySQL
In MySQL, 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 an expression.
Continue readingCOUNT() Function in MariaDB
In MariaDB, the COUNT() aggregate function returns a count of the number of non-NULL values of an expression in the rows retrieved by a SELECT statement.
AVG() Function in MariaDB
In MariaDB, the AVG() function returns the average value of the given expression.
The DISTINCT option can be used to return the average of the distinct values (i.e. remove duplicates before calculating the average).
NULL values are ignored.
SUM() Function in MariaDB
In MariaDB, 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 an expression.
Continue readingMIN() Function in MariaDB
In MariaDB, MIN() is an aggregate function that returns the minimum value in a given expression.