SQL利用Case When Then多条件判断
(1)
Select top 100 State,JoinState,
(case when State=1 and Joinstate=0 then 2 when State=1 and JoinState=1 then 1 else 0 end) as usestate from UserInfo
(2)
select ID,Username,namer=(case when(score<='50') then '实习'
when(score>'50' and score<='500' ) then '赤脚医生'
when(score>'500' and score<='1000' ) then '村卫生员'
when(score>'1000' and score<='1500' ) then '乡卫生员'
when(score>'1500' and score<='2000' ) then '镇卫生员'
when(score>'2000' and score<='3000' ) then '医师'
when(score>'3000' and score<='5000' ) then '主治医师'
when(score>'5000' and score<='10000' ) then '副主任医师'
when(score>'10000' and score<='20000' ) then '主任医师'
when(score>'20000' and score<='50000' ) then '健康大使'
else '健康大使' end ), (SELECT count(id)
FROM jk01_YiWen_Question
WHERE UserID = dbo.jk01_Member.ID) as questionnum
from jk01_Member
SQL利用Case When Then多条件判断
最新推荐文章于 2023-07-20 16:16:37 发布
本文展示了两个使用SQL语句中的Case When Then结构进行多条件判断的例子。第一个例子演示了如何根据State和JoinState字段的不同组合来设置usestate字段的值；第二个例子则展示了如何基于score字段的范围来确定用户的称号，并统计每个用户的提问数量。
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
