本文主要介绍了SQL Server行转列的方法解析。具有很好的参考价值。下面跟着小编一起来看下吧

话不多说，请看代码： /* SELECT , [第一个透视的列] AS , [第二个透视的列] AS , ... [最后一个透视的列] AS , FROM () AS PIVOT ( () FOR [] IN ( [第一个透视的列], [第二个透视的列], ... [最后一个透视的列]) ) AS ; */ declare tb table ( cid int ,cname