oralce case when then end 用法

来源:互联网 发布:话剧场景 知乎 编辑:程序博客网 时间:2024/06/04 23:23
select (case         when T_TEACHER_TRAIN_INFO.Qualified = '1' then          '合格'         when T_TEACHER_TRAIN_INFO.Qualified = '2' then          '不合格'         when T_TEACHER_TRAIN_INFO.Qualified = '合格' then          '合格'         when T_TEACHER_TRAIN_INFO.Qualified = '不合格' then          '不合格'       end) as Qualified  from T_TEACHER_TRAIN_INFO