The following table describes the supported aggregate functions.
| Function | Description |
|---|---|
avg |
Returns the average of values in a column or expression. |
count |
Returns the number of non-NULL values or the number of selected rows as integer. |
count_big |
Returns the number of non-NULL values or the number of selected rows as bigint. |
max |
Returns the maximum value in a column or expression. |
min |
Returns the minimum value in a column or expression. |
stdev |
Returns the sample standard deviation of a numeric expression as a double. |
stdevp |
Returns the population standard deviation of a numeric expression as a double. |
sum |
Returns the total sum of numeric values in a column or expression. |
var |
Returns the sample variance of a numeric expression. |
varp |
Returns the population variance of a numeric expression as a double. |
For more information, see SAP ASE functions.