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 ,然后是条件和对应结果
把大括号去了试试！~
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
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024