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) |