试试这个：

Try this:

SELECT DISTINCT StudentId, 
    (SELECT SUM(Total_marks) FROM prePivot1 AS t2 WHERE t2.StudentId = t1.StudentId AND Sub_Abbr = 'ENG') AS [ENG],
    (SELECT SUM(Total_marks) FROM prePivot1 AS t2 WHERE t2.StudentId = t1.StudentId AND Sub_Abbr = 'MBEN') AS [MBEN],
    (SELECT SUM(Total_marks) FROM prePivot1 AS t2 WHERE t2.StudentId = t1.StudentId AND Sub_Abbr = 'PSc') AS [PSc],
    (SELECT SUM(Total_marks) FROM prePivot1 AS t2 WHERE t2.StudentId = t1.StudentId AND Sub_Abbr = 'PSY') AS [PSY]
FROM prePivot1 AS t1

如何PIVOT Da使用T-SQL（SQL Server 2000,2005和2008） [ ^ ]