Offsets values within a column, partitioned by the unique values of a separate column

OFFSETBY( offset column, number of rows, partition column, sort column)

Returns a reference to a row relative to the current row, determined by the input number of rows. The offset is partitioned by a given column, or set of columns, and the offset calculation is determined by a sort parameter optionally provided.

OFFSETBY() is a window function, which performs like OFFSET() except partitioned by the unique values of a different column.




offset column

Column to return.

number of rows

Number of rows to offset. number of rows can be positive or negative.

partition column

A column, or set of columns, to partition the ranking by.

sort column

Optional, defaults to offset column . Sort value to use when determining the offset value.


Offset value


Last updated