表二里面得 0 是哪里来的呢?
代码
1
isnull(sum(
case
stdsubject when
'化学'
then Result end),
0
)
2
isnull(sum(
case
stdsubject when
'语文'
then Result end),
0
)
3
isnull(sum(
case
stdsubject when
'···'
then Result end),
0
)
4
isnull(sum(
case
stdsubject when
'···'
then Result end),
0
)
5
isnull(sum(
case
stdsubject when
'···'
then Result end),
0
)
所以得出:
代码
1
select stdname,
2
isnull(sum(
case
stdsubject when
'化学'
then Result end),
0
) [化学],
3
isnull(sum(
case
stdsubject when
'数学'
then Result end),
0
) [数学],
4
isnull(sum(
case
stdsubject when
'物理'
then Result end),
0
) [物理],
5
isnull(sum(
case
stdsubject when
'语文'
then Result end),
0
) [语文]
6
from #student
7
group by stdname
然后得出答案:
代码