Example: Using an IN List that Contains Multiple Columns with a Compatible Data Type

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

In this example, the Q101Sales column contains an INTEGER data type, and Q201Sales is a BYTEINT data type. Both the INTEGER and BYTEINT data types are compatible with each other.

SELECT * FROM star1p UNPIVOT (measure_value  FOR  yr_qtr_measure IN
(Q101Sales, Q201Sales)) Tmp;

country     state  yr_qtr_measure  measure_value
-------     -----  --------------  -------------
Canada        ON     Q201Sales               10
USA           CA     Q101Sales               30
USA           CA     Q201Sales               50
USA           NY     Q101Sales               45