SQL case语句问题
发布网友
发布时间：2022-04-22 07:37
共2个回答
热心网友
时间：2022-06-17 21:10
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' 附近有语法错误。
热心网友
时间：2022-06-17 21:11
把大括号去了试试！~
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
