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.