现在有怎么一个算法, A>B 则为C
A<B -- 如果A+C<=B 则0
A+C>B 则A+C-B
==================
select case when a>b then c
else case when A+C<=B then 0 elase A+C-B end
end
from table
这个不行,求教??
A<B -- 如果A+C<=B 则0
A+C>B 则A+C-B
==================
select case when a>b then c
else case when A+C<=B then 0 elase A+C-B end
end
from table
这个不行,求教??
A>B 则为C
A<B -- 如果A+C<=B 则0
A+C>B 则A+C-B
==================
select case when a>b then c
else case when A+C<=B then 0 elase A+C-B end
end
from table
这个不行,求教??
----------------------------
你錯了
select case when a>b then c
when A+C<=B then 0
else A+C-B end
end
from table
=======
我试试