Aggregate functions return a single value, calculated from values in a column.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 |