Skip to main content Link Menu Expand (external link) Document Search Copy Copied

Aggregate Functions

Function Description Example
avg(arg) returns the average value of all tuples in arg avg(a.length)
count(arg) returns the number of tuples in arg count(a.ID)
min(arg) returns the minimum value of arg min(a.legnth)
max(arg) returns the maximum value of arg max(a.length)
sum(arg) returns the sum value of all tuples in arg sum(a.length)
collect(arg) returns a list containing values returned by arg expression collect(a.age)