16.20 - 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
Release Date
March 2019
Content Type
Release Notes
Publication ID
B035-1098-162K
Language
English (United States)

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.