SQLにおけるPIVOT操作の方法

基本的なPIVOT操作の例:SELECT * FROM ( SELECT category, product, sales FROM sales_table ) AS source_table PIVOT ( SUM(sales) FOR product IN ([Product A], [Product B], [Product C]) ) AS pivot_table;>>More