SQL
Aggregate Functions API Reference
SQL aggregate functions for summarizing grouped rows.
By EZ4Code Team
Aggregate Functions
Functions that operate on a set of rows and return a single value.
COUNT(expr)Return the number of non-null values of expr. COUNT(*) counts all rows.
Returns: int
SUM(expr)Return the sum of expr across non-null values.
Returns: numeric
AVG(expr)Return the arithmetic mean of expr across non-null values.
Returns: numeric
MIN(expr)Return the minimum value of expr across non-null values.
Returns: any
MAX(expr)Return the maximum value of expr across non-null values.
Returns: any
GROUP_CONCAT(expr SEPARATOR sep)Concatenate non-null values of expr into a single string. (MySQL; STRING_AGG in PostgreSQL / SQL Server.)
Returns: string