16.20 - Aggregation of Pivoted Columns - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

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.