模板:
case
when [表达式1] then [事件1]
when [表达式n] then [事件n]
else [默认事件]
end [别名]
示例:
select t.name,
case
when t.grade = '90' then '优秀'
when t.grade = '70' then '一般'
else '差'
end expr
from student;
模板:
case
when [表达式1] then [事件1]
when [表达式n] then [事件n]
else [默认事件]
end [别名]
示例:
select t.name,
case
when t.grade = '90' then '优秀'
when t.grade = '70' then '一般'
else '差'
end expr
from student;