The partition_clause
defines expressions that Exasol uses to partition the result set. To compute the result for a row, the function operates only on the rows in the partition containing the current row. Without the partition_clause
, Exasol treats the entire result set as a single partition. If the query does not specify an order_clause
nor a window_frame_clause
, the default window_frame_clause
is ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
.