我想将下面这个语句转化成sql里面的语句,应该怎么转化呀?
select name,decode(result,'优','0','良','1','中','2','差','3','4') as result from mjg_temp"如果是动态绑定一组优,良,中,差在这个里面,又应该怎么写呢?
select name,decode(result,'优','0','良','1','中','2','差','3','4') as result from mjg_temp"如果是动态绑定一组优,良,中,差在这个里面,又应该怎么写呢?
name,
case result
when '优' then '0'
when '良' then '1'
when '中' then '2'
when '差' then '3'
else '4'
end as result
from mjg_temp
name,
(case result
when '优' then '0'
when '良' then '1'
when '中' then '2'
when '差' then '3'
else '4'
end
) as 'result'
from mjg_temp