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