Version 1.13
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' [,...]) ]
[ DefaultPivotValues ('default_pivot_value' [,...]) ]
[ NumericPivotKey ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
}
TargetColumns ({ 'target_column' | 'target_column_range' }[,...])
) AS alias;