Result Title - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
Product Category
Teradata Vantage™

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)