case when then

最新推荐文章于 2024-10-22 18:00:00 发布

转载最新推荐文章于 2024-10-22 18:00:00 发布 · 163 阅读

此博客展示了如何使用SQL查询来获取特定医疗人员的等级（实习、赤脚医生等）以及他们所提出的问题数量。通过复杂的CASE语句判断医疗人员的等级，并统计其提出的问题总数。

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



原文自：http://www.cnblogs.com/kevin2013/archive/2010/07/02/1769682.html