Applies to: Databricks SQL Databricks Runtime
Returns the value at a specific
offset in the window.
The result type matches the
The window function returns the value of
expr at the row that is the
offsetth row from the beginning of the window frame.
If there is no such
offsetth row, returns
You must use the ORDER BY clause clause with this function. If the order is non-unique, the result is non-deterministic.