Case语句的用法

1.简单Case函数写法(注意sex的位置)
select *,(CASE sex WHEN ‘1’ THEN ‘男’ WHEN ‘0’ THEN ‘女’ ELSE ‘保密’ END) as sex_text
from user

2.Case搜索函数写法(注意sex的位置【推荐】)
select *,(CASE WHEN sex=’1’ THEN ‘男’ WHEN sex=’0’ THEN ‘女’ ELSE ‘保密’ END) as sex_text
from user

总结：简单Case函数写法只适合相等条件判断，不能用于大于、小于及不等于的判断，

其它示例：
      declare mycur1 cursor for select 工资下限, 工资上限, case when       --
          个人所得税率>1 then  个人所得税率/100 else 个人所得税率 end
          from 个人所得税表 where 工资上限 <= @gzhj order by 工资上限

原文链接：https://blog.csdn.net/c15158032319/article/details/122162485