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.
계속 탐색
전자책
Unlock the value of AI/ML with AWS and Teradata
지금 다운로드
웨비나
Deploying Analytics at Scale in Financial Services with Teradata VantageCloud and Amazon SageMaker
지금 보기
애널리스트 콘텐츠
IDC MarketScape: Worldwide Customer Data Platforms Focused on Data and Marketing Operations Users 2022 Vendor Assessment
지금 다운로드
사례 연구
Dynamic Supply Chain
지금 다운로드