请大家帮忙看看这句话中有没有问题
case a.value when a.id=386 then (a.value where a.id=363-a.value where a.id=362)
when a.id=15000 then (a.value where a.id=407+a.value where id=789 - a.id where a.id =408-a.value where a.id=790)
else a.value end
case a.value when a.id=386 then (a.value where a.id=363-a.value where a.id=362)
when a.id=15000 then (a.value where a.id=407+a.value where id=789 - a.id where a.id =408-a.value where a.id=790)
else a.value end
楼主的 实在耐人寻味这么多where
a.id=15000时,a.value的值为四个value值的加减结果
其他id值时,a.value=a.value
我要的结果是 当a.id=386时,a.value=两个value值的差
a.id=15000时,a.value的值为四个value值的加减结果
其他id值时,a.value=a.value
a.value=case when a.id=386 then 你的计算差的方法
when a.id=15000 then 四个value值的加减结果
else a.value end
when a.id=15000 then (select a.value from a where a.id=407)+(select a.value from a where a.id=789) -(select a.value from a where a.id=408)-(select a.value from a where a.id=790)
else a.value end from a
select case when a.id=386 then ((select a.value from a where a.id=363)-(select a.value from a where a.id=362))
when a.id=15000 then ((select a.value from a where a.id=407)+(select a.value from a where a.id=789) -(select a.value from a where a.id=408)-(select a.value from a where a.id=790))
else a.value end from a