Aggregate functions return a single value, calculated from values an expression passed as parameter to the function evaluates to for selected rows.
| Function | Arity | Description | ||
|---|---|---|---|---|
| AVG(x) | 1 | Returns average value | ||
| COUNT(x) | 1 | Returns number of rows | ||
| MAX(x) | 1 | Returns largest value | ||
| MIN(x) | 1 | Returns smallest value | ||
| SUM(x) | 1 | Returns sum | ||
| FIRST(x) | 1 | Returns value of the given expression evaluated for the first row of the query's result set | ||
| LAST(x) | 1 | Returns value of the given expression evaluated for the last row of the query's result set | ||
| STDEV(x) | 1 | Compute standard deviation | ||
| VAR(x) | 1 | Compute variance | ||
| RMS(x) | 1 | Compute Root Mean Square of x | ||
| DOTP(x,y) | 2 | Compute dot product of x and y | ||
| NORM(x,y) | 2 | Compute the norm of x,y |