SELECT * FROM Unpivot ( ON unpivot_input Unpivot ('temp', 'pressure', 'dewpoint') AttributeColumn ('climate_attributes') ValueColumn ('attributevalue') InputTypes ('true') Accumulate ('sn', 'city', 'week') ) ORDER BY 1,2,3;
SELECT * FROM Unpivot ( ON unpivot_input Unpivot ('temp', 'pressure', 'dewpoint') AttributeColumn ('climate_attributes') ValueColumn ('attributevalue') InputTypes ('true') Accumulate ('sn', 'city', 'week') ) ORDER BY 1,2,3;