您可以使用条件聚合来执行交叉表：
SELECt Item, [X] = MAX(CASE WHEN [Columns] = 'X' THEN Result END), [Y] = MAX(CASE WHEN [Columns] = 'Y' THEN Result END), [Z] = MAX(CASE WHEN [Columns] = 'Z' THEN Result END)FROM thisTableGROUP BY Item
您可以使用条件聚合来执行交叉表：
SELECt Item, [X] = MAX(CASE WHEN [Columns] = 'X' THEN Result END), [Y] = MAX(CASE WHEN [Columns] = 'Y' THEN Result END), [Z] = MAX(CASE WHEN [Columns] = 'Z' THEN Result END)FROM thisTableGROUP BY Item
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
