Aggregate
Last updated
Was this helpful?
Last updated
Was this helpful?
Returns any value from the input or NULL if there are zero input rows –>
dynamic (input-dependent)
@variable
true
-
Returns the average of all non-null values –>
float
@variable
true
-
integer
@variable
false
(*)
@distinct
true
-
boolean
@variable
true
-
boolean
@variable
true
-
dynamic (input-dependent)
@variable
true
-
dynamic (input-dependent)
@variable
true
-
string
@variable
true
-
@delimiter
false
(",")
@distinct
true
-
@limit
false
-
dynamic (input-dependent)
@variable
true
-
any
any ,
Returns the count of all non-null values –>
any
any
Returns the logical AND of all non-NULL expressions –>
any
Returns the logical OR of all non-NULL expressions –>
any
Returns the maximum value of all non-null inputs –>
any
Returns the minimum value of all non-null inputs –>
any
Returns a string obtained by concatenating all non-null values –>
any
any
any
any
Returns the sum of all values, ignoring nulls –>
any ,