LAST_VALUE

LAST_VALUE(COLUMN_EXPRESSION)

Select the last value in the window or NULL if the window is empty. Supported on all non-semi-structured types.

Note

When used as a window function with an ORDER BY clause but no window frame, ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW is used by default.