1、PIVOT用法(行转列). select * from Table_Score as a pivot (sum(score) for a.name in ([语文],[数学],[外语],[文综],[理综])) as b. 数据:. id name score
確定! 回上一頁