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.
Erkunden Sie weiter
Webinar
Privacy Principles for Enterprise Data Assets
Jetzt ansehen
White Paper
Choosing the Analytic Solution to Meet Business Requirements
Jetzt downloaden
Broschüre
Discover a better way to accelerate Artificial Intelligence/Machine Learning
Jetzt downloaden
Kundenvideo
Data and Analytics Fuel Business-Critical Operations for American Airlines
Jetzt ansehen