case when t.wshifts = '14:00' then '一班'= end k_shifts,
case when t.wshifts= '22:00' then '二班' end k_shifts,
如何用一个case when表达
case when t.wshifts = '14:00' then '一班' when t.wshifts= '22:00' then '二班' end k_shifts,
case when t.wshifts = '14:00' then '一班' when t.wshifts= '22:00' then '二班' else ''end k_shifts
case when t.wshifts = '14:00' then '一班'
when t.wshifts= '22:00' then '二班' end k_shift
case t.wshifts when '14:00' then '一班' when '22:00' then '二班' end k_shifts