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. |