SQL case语句问题

2025-02-24 12:41:04

推荐回答（2个）

回答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 ,然后是条件和对应结果

回答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