Version 1.9
SELECT * FROM Pivoting ( ON { table | view | (query) } PARTITION BY partition_column [,...] [ ORDER BY order_column ] USING PartitionColumns ({ 'partition_column' | partition_column_range }[,...]) { NumberOfRows (number_of_rows) | PivotColumn ('pivot_column') [ PivotKeys ('pivot_key' [,...]) ] [ NumericPivotKey ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ] } TargetColumns ({ 'target_column' | 'target_column_range' }[,...]) ) AS alias;