case when oracle语法
-- 按成绩将学生分组 select name, score, case when score >= 90 then '优秀' when score >= 80 then '良好' when score >= 70 then '中等' when score >= 60 then '及格' else '不及格' end as level from student; -- 将性别转换为中文 select name, sex, age, case sex when 'M' then '男' when 'F' then '女' end as sex_zh from student; -- 统计不同区间范围的订单数量 select count(*) as order_num, case when amount
