要求then后面的数据类型必须一致
select
*,
头衔=case
when [level]=1 then '菜鸟'
when [level]=2 then '老鸟'
when [level]=3 then '大师'
end
From [user]
相当于switch
select
*,
头衔=case [level]
when 1 then '菜鸟'
when 2 then '老鸟'
when 3 then '大师'
else '骨灰级大师'
end
from [user]
select
tscoreId,
tsid,
tenglish,
等级=case
when tenglish>=95 then '优',
when tenglish>=95 then '良',
when tenglish>=95 then '中',
else '差'
end
from TblXccore
select
球队名称=teamName,
胜=sum(
case
when ganmeResult='胜' then 1
else 0
end),
负=sum(
case
when ganmeResult='胜' then 0
else 0
end)
from TeamSore
group by teamName
select
球队名称=teamName,
胜=count(
case
when gameResult ='胜' then '胜'
else null
end),
负=count(
case
when gameResult ='负' then '负'
else null
end)
from TeamScore
group by teamName