16.10 - PIVOT and UNPIVOT - Teradata Database

Teradata Database Release Summary

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Release Notes
featnum
B035-1098-161K

The PIVOT and UNPIVOT operators provide simple syntax to transform rows into columns, and columns into rows, providing users with flexibility and ease of use. Using PIVOT and UNPIVOT makes it easier to port applications to the Teradata Database.

Benefits

  • The PIVOT operator provides an easy mechanism to transform rows into columns. The function is also useful for reporting purposes, as it allows users to aggregate and rotate data and create meaningful, easy-to-read tables.
  • The UNPIVOT operator works the opposite of PIVOT, transforming columns into rows, and can transform non-normalized data into a normalized result set.

SQL Changes

The SELECT statement is extended to support PIVOT and UNPIVOT operators in the FROM clause.

Additional Information

For more information on PIVOT and UNPIVOT, see SQL Functions, Operators, Expressions, and Predicates.