select (case 金额类别 when '收入' then 1 else -1 end) * (金额1-金额2) from tb
select sum((case 金额类别 when '收入' then 1 else -1 end) * (金额1-金额2)) from tb
select sum( (case 金额类别 when '收入' then 1 else -1 end) * (金额1-金额2) ) from tb
SELECT SUM(CASE WHEN 金额类别='收入' THEN 金额1-金额2 ELSE 0 END) -SUM(CASE WHEN 金额类别='支出' THEN 金额1-金额2 ELSE 0 END) FROM tb
SELECT SUM(金额1)-SUM(金额2) FROM tb
select (select sum(金额1-金额2) from tb where 金额类别='收入') - (select sum(金额1-金额2) from tb where 金额类别='支出')
((select sum('金额1') from '表名' where 金额类别=N'收入') -(select sum('金额2') from '表名' where 金额类别=N'收入')) - ((select sum('金额1') from '表名' where 金额类别=N'支出')- (select sum('金额2') from '表名' where 金额类别=N'支出'))
select (case 金额类别 when '收入' then 1 else -1 end) * (金额1-金额2)
from tb
from tb
from tb
-SUM(CASE WHEN 金额类别='支出' THEN 金额1-金额2 ELSE 0 END)
FROM tb
SELECT SUM(金额1)-SUM(金额2)
FROM tb
(select sum(金额1-金额2) from tb where 金额类别='支出')
-(select sum('金额2') from '表名' where 金额类别=N'收入'))
-
((select sum('金额1') from '表名' where 金额类别=N'支出')-
(select sum('金额2') from '表名' where 金额类别=N'支出'))