高分求SQL语句

Question

select ....
,case when mp_workage.value>'G' then a.otnonsunday+a.otsunday else a.otsunday
end
from .....

Answer 1

select ....
,case when mp_workage.value>'G' then isnull(a.otnonsunday,0)+isnull(a.otsunday,0) else a.otsunday
end as 字段
from .....

Answer 2

在选择列表中加上 ,case when mp_workage.value>'G' then a.otnonsunday+a.otsunday else a.otsunday end

Answer 3

lastfieldname=case when mp_workage.value>'G' then a.otnonsunday+a.otsunday else a.otsunday
end