max

max — aggregate function to return the maximum of a range of values.

SYNOPSIS

max (expr)

DESCRIPTION

This function computes a value for each record returned by the query predicate, and returns the maximum non-null value determined using the greater-than relational operation appropriate for the data type of the specified values. The effect of relational operators on each LiveView data type are the same as those for StreamBase expression language data types, as described in StreamBase Data Types. The returned value is the same type as the argument.

SEE ALSO

This LiveView aggregate function is based on the max aggregate function in the StreamBase expression language.