LAST_VALUE returns the evaluation of the from the last row that qualifies for the aggregate.
LAST_VALUE ( < - value-expression> ) Â OVER < - window-specification>
Null treatment option | Effect |
---|---|
LAST_VALUE(x) IGNORE NULLS OVER <window-specification > | Returns last non null value of x in <window-specification > |
LAST_VALUE(x) RESPECT NULLS OVER <window-specification > | Returns last value, including null of x in <window-specification > |
LAST_VALUE(x) OVER <window-specification > | Returns last value, including null of x in <window-specification > |
See the topic WINDOW clause of the SELECT statement for more details on defining windows.