Video

Microlearning: PIVOT - Preselecting Columns in SQL

Watch video

This video demonstrates how to use PIVOT as an easy way to transform row values into columns.

Use your Teradata Vantage platform to try what you see demonstrated in the video http://www.tensupport.com/video_sql/Pivot1.sql.

You can get more in-depth knowledge about pre-selecting columns using PIVOT from Teradata Documentation Online at https://docs.teradata.com/r/ITFo5Vgf23G87xplzLhWTA/FdmKXyuSV7OTeVF~E87BoQ.

To experience Vantage today and request a free trial, visit https://www.teradata.com/Vantage/Trial.

Topics

Microlearning: Teradata Vantage SQL Syntax for Advanced SQL Engine Functions

Microlearning: Using FORMAT with Dates in SQL

Microlearning: Creating Tables in SQL