Microlearning: PIVOT - Aggregating the Generated Column in SQL
This video demonstrates how PIVOT is an easy way to aggregate a subset of row values, and transform them into columns. Use your Teradata Vantage platform to try what you see demonstrated in the video: http://www.tensupport.com/video_sql/Pivot2.sql.
You can get more in-depth knowledge about how PIVOT can be used to aggregate generated columns from Teradata Documentation Online at https://docs.teradata.com/r/1Ms8rWHdBhcwr0PzwAWcDw/0b1bz2mRSvXlhhTwCyf4cA.
To experience Vantage today and request a free trial, visit https://www.teradata.com/Vantage/Trial.