use student
go
select stu_id,grade,701,702,703,801,802,803,804
from stu_grade
pivot
(
count(course_id)
for course_id
in(701,702,703,801,802,803,804)
)as pvt
附上数据库
stu-id course-id grade
2007070101 701 89
2007080101 701 NULL
2007070101 703 96
2007080101 802 87
2007070102 702 74
2007080102 802 50
2007070102 703 55
2007080201 803 75
2007070104 701 35
2007080201 804 82