Aggregation of Pivoted Columns - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
hqm1512077988481.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1098
lifecycle
previous
Product Category
Software
Teradata Vantage

PIVOT syntax has been enhanced to support the aggregation of PIVOT results. The new syntax option to use for this aggregation is WITH.

Benefits

  • Improves the flexibility of the PIVOT function. You can use the enhanced syntax to aggregate resultant PIVOT columns, thereby avoiding writing complex SQL JOIN statements for aggregation.
  • Performance is improved because you do not need to write JOIN statements to perform aggregation.

Considerations

This feature is a Teradata extension to the ANSI SQL standard.

Additional Information

For more information, see PIVOT and UNPIVOT and PIVOT in Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates, B035-1145.