请问这句话哪里错了?
他老是说as附近有语法错误..真郁闷
sum(case([testscore] as int))
整个查询是
select
[stuid],
[stuname],
[数学]=max(case when [testname]='数学' then [testScore] else 0 end),
[物理]=max(case when [testname]='物理' then [testScore] else 0 end),
[英语]=max(case when [testname]='英语' then [testScore] else 0 end),
[语文]=max(case when [testname]='语文' then [testScore] else 0 end),
[总分]=sum(case([testscore] as int))
from testscore
group by [stuid],[stuname]GO去掉总分那列 就能运行. 谁告诉我错哪了 该怎么改?
他老是说as附近有语法错误..真郁闷
sum(case([testscore] as int))
整个查询是
select
[stuid],
[stuname],
[数学]=max(case when [testname]='数学' then [testScore] else 0 end),
[物理]=max(case when [testname]='物理' then [testScore] else 0 end),
[英语]=max(case when [testname]='英语' then [testScore] else 0 end),
[语文]=max(case when [testname]='语文' then [testScore] else 0 end),
[总分]=sum(case([testscore] as int))
from testscore
group by [stuid],[stuname]GO去掉总分那列 就能运行. 谁告诉我错哪了 该怎么改?
-->
[总分]=sum(cast([testscore] as int))