先看下表的前后变化:变化前
变换后:
下面是变换的方法:
select FNumber,
(
case
when FAmount>0 then FAmount
else 0
end
) as 收入,
(
case
when FAmount<0 then ABS(FAmount)
else 0
end
) as 支出
from Tb_1
思想:选取表,把表中大于0的作为一种case,小于0作为另一种case。
先看下表的前后变化:变化前
变换后:
下面是变换的方法:
select FNumber,
(
case
when FAmount>0 then FAmount
else 0
end
) as 收入,
(
case
when FAmount<0 then ABS(FAmount)
else 0
end
) as 支出
from Tb_1
思想:选取表,把表中大于0的作为一种case,小于0作为另一种case。