用sql写一个关于爆炸函数的行转列

SQL语言中可以使用PIVOT关键字实现行转列。下面是一个简单的例子：

WITH data AS (
  SELECT 'A' AS item, 'apple' AS description, 10 AS quantity UNION ALL
  SELECT 'B' AS item, 'banana' AS description, 20 AS quantity UNION ALL
  SELECT 'C' AS item, 'cherry' AS description, 30 AS quantity
)
SELECT *
FROM data
PIVOT (SUM(quantity) FOR item IN ('A' AS A, 'B' AS B, 'C' AS C))