17,382
社区成员




select A,B,
(case when a>0 and b>0 then a/b
when a<0 and b>0 then 1-a/b
when a>0 and b<0 then a/b-1
when a<0 and b<0 then 2-a/b end) C,
(case when a>0 and b>0 then 'a/b'
when a<0 and b>0 then '1-a/b'
when a>0 and b<0 then 'a/b-1'
when a<0 and b<0 then '2-a/b'end) D
from tab;
select case when sign(A) =1 and sign(B)=1 then A/B
when sign(A) =-1 and sign(B)=1 then 1-A/B
when sign(A) =1 and sign(B)=-1 then A/B-1
when sign(A) =-1 and sign(B)=-1 then 2-A/B end from tab
大概这样,试试