Aggregate functions return a single value, calculated from values an expression passed as parameter to the function evaluates to for selected rows.

FunctionArityDescription
AVG(x)1Returns average value
COUNT(x)1Returns number of rows
MAX(x)1Returns largest value
MIN(x)1Returns smallest value
SUM(x)1Returns sum
FIRST(x)1Returns value of the given expression evaluated for the first row of the query's result set
LAST(x)1Returns value of the given expression evaluated for the last row of the query's result set
STDEV(x)1Compute standard deviation
VAR(x)1Compute variance
RMS(x)1Compute Root Mean Square of x
DOTP(x,y)2Compute dot product of x and y
NORM(x,y)2Compute the norm of x,y