Result Title

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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)