16.20 - Result Title - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

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)