ShowAggregateFunctions

Table of Contents



Lists the built-in aggregate functions with their parameters and descriptions.

ShowAggregateFunctions()

Name, ReturnType, Parameters and Description. Each prototype is also returned as a message.

round-pushpin Lists the aggregate functions.
EXEC ShowAggregateFunctions




SQL :: Exec
Exec runs a system procedure.
SQL :: Expressions
Literals, operators, comments and variables in KBSQL.
SQL :: GeometricMean
Returns the geometric mean of the values in each group: the nth root of their product. Useful for growth rates and ratios.
SQL :: Group By
Group by collapses a result set into one row per distinct set of values.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: Max
Returns the largest numeric value in each group. Use MaxString for text.
SQL :: MaxString
Returns the alphabetically largest value in each group.
SQL :: Mean
Returns the arithmetic mean of the values in each group (the same as Avg).
SQL :: Median
Returns the median (middle) value in each group. For an even number of values it is the average of the two middle values.
SQL :: Min
Returns the smallest numeric value in each group. Use MinString for text.