SQL利用Case When Then多条件判断

最新推荐文章于 2023-07-20 16:16:37 发布

joyu1314

最新推荐文章于 2023-07-20 16:16:37 发布

阅读量653

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/joyu1314/article/details/2853507

版权

本文展示了两个使用SQL语句中的Case When Then结构进行多条件判断的例子。第一个例子演示了如何根据State和JoinState字段的不同组合来设置usestate字段的值；第二个例子则展示了如何基于score字段的范围来确定用户的称号，并统计每个用户的提问数量。

摘要由CSDN通过智能技术生成

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