OFFSETBY

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.

Arguments

Output

Offset value

Example

Last updated