Microlearning: PIVOT: Issuing Subqueries in PIVOT IN-List in SQL
This video demonstrated how to use a subquery instead of an In-List when using PIVOT to transform row values into columns.
Use your Teradata Vantage platform to try what you see demonstrated in the video: https://www.tensupport.com/video_sql/Pivot3.sql.
You can get more in-depth knowledge about subqueries in a PIVOT IN-List from Teradata Documentation Online at https://docs.teradata.com/r/1Ms8rWHdBhcwr0PzwAWcDw/UHlv9ygDvJFWnIIH_a1xwg.
To experience Vantage today and request a free trial, visit https://www.teradata.com/Vantage/Trial.