lastval
lastval function — Dynamic aggregate function for lastval
DESCRIPTION
Computes a value for each record returned by the query predicate and returns the last
value from the range of values returned. Expression expr
must be a StreamBase expression. The returned
last value is the same type as expr
. If the
query returns no rows, the aggregate returns null
.
The function name is case-sensitive. This function exists for dynamic (query-based) aggregation only.