case表达式用于实现多路分支结构
语法格式:
case exp when comparison_exp1 then return_exp1
[when comparison_exp2 then return_exp2
when comparison_expn then return_expn
else else_exp]
end
用法举例:
select empno, ename, sal,
case deptno when 10 then '财务部'
when 20 then '研发部'
when 30 then '销售部'
else '未知部门'
end部门
from emp;
语法格式:
case exp when comparison_exp1 then return_exp1
[when comparison_exp2 then return_exp2
when comparison_expn then return_expn
else else_exp]
end
用法举例:
select empno, ename, sal,
case deptno when 10 then '财务部'
when 20 then '研发部'
when 30 then '销售部'
else '未知部门'
end部门
from emp;