Window functions

next()

Learn how to use the next() function to return the value of the next column at an offset.

prev()

Learn how to use the prev() function to return the value of a specific column in a specified row.

row_cumsum()

Learn how to use the row_cumsum() function to calculate the cumulative sum of a column in a serialized row set.

row_number()

Learn how to use the row_number() to return the current row’s index in a serialized row set.

row_rank_dense()

Learn how to use the row_rank_dense() function to return the current row’s dense rank in a serialized row set.

row_rank_min()

Learn how to use the row_rank_min() function to return the current row’s minimal rank in a serialized row set.

row_window_session()

Learn how to use the row_window_session() function to calculate session start values of a column in a serialized row set.

Window functions

Learn how to use window functions on rows in a serialized set.