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 |