Numeric functions¶
Here is a list of numeric functions supported by Mammoth. In other words, these functions produce numbers as their output.
Function |
Description |
---|---|
COUNT |
This function returns the row count. |
SUM |
This function returns the sum of a given column. This can be be used on numeric columns. |
AVG |
This function returns the average of a given column. This can be be used on numeric columns. |
MIN |
This function returns the minimum value of a given column. This can be be used on numeric numeric. |
MAX |
This function returns the maximum value of a given column. This can be be used on numeric columns. |
STTDDEV |
This function returns the standard deviation of the values of a given column. This can be be used on numeric columns. |
VARIANCE |
This function returns the variance of the values of a given column. This can be be used on numeric columns. |
INT |
This function returns the integer part of the input given to it. For example
|