This example specifies a range of target columns and uses the default values for the optional arguments.
Input
- Input table: unpivot_input, as in Unpivoting Example 1: Specified Target Columns, Default Optional Values
SQL Call
This call is equivalent to the call in Example 1Unpivoting Example 1: Specified Target Columns, Default Optional Values.
SELECT * FROM Unpivoting ( ON unpivot_input USING TargetColumns ('[3:5]') Accumulate ('sn', 'city', 'week') InputTypes ('false') ) AS dt ORDER BY 1, 2, 3;
Output
The output is the same as in Unpivoting Example 1: Specified Target Columns, Default Optional Values.