The default title that appears in the heading for displayed or printed results depends on the type of computation performed.
| IF the type of computation is … | THEN the result title is … |
|---|---|
| cumulative | Cumulative Function_name (argument_list) For example, consider the following computation: SELECT AVG(sales) OVER (PARTITION BY region ORDER BY smonth ROWS UNBOUNDED PRECEDING) FROM sales_history; The title that appears in the result heading is: Cumulative Avg(sales) |
| group | Group Function_name (argument_list) For example, consider the following computation: SELECT AVG(sales) OVER (PARTITION BY region ORDER BY smonth ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM sales_history; The title that appears in the result heading is: Group Avg(sales) |
| moving | Moving Function_name (argument_list) For example, consider the following computation: SELECT AVG(sales) OVER (PARTITION BY region ORDER BY smonth ROWS 2 PRECEDING) FROM sales_history; The title that appears in the result heading is: Moving Avg(sales) |
| remaining | Remaining Function_name (argument_list) For example, consider the following computation: SELECT AVG(sales) OVER (PARTITION BY region ORDER BY smonth ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) FROM sales_history; The title that appears in the result heading is: Remaining Avg(sales) |