SELECT
Student, [English], [Mathematics], [Science], [Programming], [History]
FROM
(SELECT Student, Grades, Subject
FROM Grade_Report) AS SOURCETABLE
PIVOT
(SUM(Grades)
FOR Subject IN ([English], [Mathematics], [Science], [Programming], [History])
) AS PIVOTTABLE
輸出：
Jamie 188.00 161.00 163.00 183.00 184.00
Jenny 175.00 173.00 174.00 172.00 172.00
Jerome 184.00 186.00 184.00 191.00 181.00
預期輸出：
Jamie 94 80.50 81.50 91.50 92
Jenny 87.50 86.50 87 86 86
Jerome 92 93 92 95.50 90.50
uj5u.com熱心網友回復：
每個學生每個科目可能有兩個分數？首先確保這一點
嘗試使用平均AVG(Grades)
SELECT
Student, [English], [Mathematics], [Science], [Programming], [History]
FROM
(SELECT Student, Grades, Subject
FROM Grade_Report) AS SOURCETABLE
PIVOT
(AVG(Grades)
FOR Subject IN ([English], [Mathematics], [Science], [Programming],
[History])
)
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/360641.html