Skip to main content

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!