SQL利用Case When Then多条件判断SQL 语句

最新推荐文章于 2024-02-18 23:43:34 发布

雨轩_wscrf

最新推荐文章于 2024-02-18 23:43:34 发布

阅读量2.3k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/wscrf/article/details/78362617

版权

mysql 专栏收录该内容

36 篇文章 0 订阅

订阅专栏

SQL利用Case When Then多条件判断SQL 语句
(1)
Select top 100 State,JoinState,
(casewhen State=1 and Joinstate=0 then 2 when State=1 and JoinState=1 then 1else 0 end)
as usestate from UserInfo
(2)
select ID,Username,namer=(casewhen(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