是的，我想是这样。使用MAX汇总很容易进行这样的枢轴操作：
SELECT
*
FROM
(
SELECT
project,
attribute,
value
FROM
table1
) AS SourceTable
PIVOT
(
MAX(value)
FOR attribute IN ([foo],[bar],[baz])
) AS pvt
否则，您必须在max聚合内执行case语句。像这样：
SELECT
MAX(CASE WHEN attribute='foo' THEN value ELSE NULL END) AS foo,
MAX(CASE WHEN attribute='bar' THEN value ELSE NULL END) AS bar,
MAX(CASE WHEN attribute='baz' THEN value ELSE NULL END) AS baz,
project
FROM
table1
GROUP BY
project
这几乎和做PIVOT。但我宁愿做PIVOT在CASE WHEN MAX..
602392714
清零编程群