Window functions

Window functions perform calculations using values from multiple rows to produce a value for each row separately. Window functions can only be calculated once the entire table is read.

You can use window functions to perform operations such as:

• Comparing an individual number value in a row with the average, maximum, or minimum within the column.

• Calculating the rank of an individual value, either within the column or within the entire table.

Window functions do not change the number of records in the table but can perform similar tasks as aggregation functions or relational functions and range functions.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

Window

The Window function performs calculations from multiple rows, producing a value for each row separately.

Window(input_expr, [partition1, partition2, ...], [sort_type, [sort_expr]],[filter_expr], [start_expr,end_expr])[row_window_size])

WRank

The WRank function performs ranking calculations inside Window.

WRank([TOTAL] expr[, mode[, fmt]])