lastval

lastval function — Dynamic aggregate function for lastval

SYNOPSIS

lastval (expr)

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.