Result Title - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The default title that appears in the heading for displayed or printed results depends on the type of computation performed.

Computation Type Rsult Title
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)