×
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.
Continue exploring
Datasheet
Data Protection and Security for Financial Services
Download now
Technical Video
TechBytes: Analytics 123 | 3. Connecting to Vantage and GUI Options
Watch now
Analyst Content
Information Difference - Big Data Warehouse Landscape Q4 2021
Download now
White Paper
Vantage as a Google Cloud Managed Application Cloud Service Description
Download now