Reference Guide > TDV Support for SQL Functions > Analytical Functions > LAST_VALUE
 
LAST_VALUE
LAST_VALUE returns the last value in an ordered set of values.
Syntax
LAST_VALUE (expression) [IGNORE NULLS] OVER (window_clause)
Remarks
If the last value in the set is NULL, the function returns NULL unless you specify IGNORE NULLS.
IGNORE NULLS is useful for data densification.