在SQLServer2005 +中可能使用PIVOT
SELECt ID, valueHeading1, valueHeading2FROM( SELECt * FROM dbo.test28 WHERe valueHeading IN ('valueHeading1', 'valueHeading2') ) x PIVOT ( MAX(value) FOR valueHeading IN ([valueHeading1], [valueHeading2]) ) p
在SQLServer2005 +中可能使用PIVOT
SELECt ID, valueHeading1, valueHeading2FROM( SELECt * FROM dbo.test28 WHERe valueHeading IN ('valueHeading1', 'valueHeading2') ) x PIVOT ( MAX(value) FOR valueHeading IN ([valueHeading1], [valueHeading2]) ) p名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
