Question

SQL case语句问题

select Name,
sum({
case Score
when N'胜' then 1
else 0
end
}) as 胜,
sum({
case Score
when N'败' then 1
else 0
end
}) as 败
from T_Score
group by Name

我是根据教程打的，为什么老报错，以前成功过1次
Msg 156, Level 15, State 1, Line 3
关键字 'case' 附近有语法错误。
到底错在哪了，我换别的例子只要遇到case语句都报这错

Answer 1

select Name,
sum({
case
when Score = N'胜' then 1
else 0
end
}) as 胜,
sum({
case
when Score = N'败' then 1
else 0
end
}) as 败
from T_Score
group by Name

case 后要直接跟when ,然后是条件和对应结果

追问

还是Msg 156, Level 15, State 1, Line 3
关键字 'case' 附近有语法错误。

Answer 2

把大括号去了试试！~

select Name,
sum(
case Score
when N'胜' then 1
else 0
end
) as 胜,
sum(
case Score
when N'败' then 1
else 0
end
) as 败
from T_Score
group by Name