sql server两行相减

公式：

select a.qty-b.qty
from tableA a,tableB b
where a.number=b.number

不同步表行相减：

select  a.month1-b.month1 ,a.month2-b.month2,a.month3-b.month3,a.month4-b.month4,a.month5-b.month5,a.month6-b.month6,
a.month7-b.month7,a.month8-b.month8,a.month9-b.month9,a.month10-b.month10,a.month11-b.month11,a.month12-b.month12,a.lastYear-b.lastYear,a.qianYear-b.qianYear,'','','','',0, a.sumqty-b.sumqty
from GouJinZiZhiTongJiTable1 a,GouJinZiZhiTongJiTable2 b
where  a.rowid=b.rowid

同一张表两不同行同一月份进行相减：

select  a.month1-b.month1 ,a.month2-b.month2,a.month3-b.month3,a.month4-b.month4,a.month5-b.month5,a.month6-b.month6,
a.month7-b.month7,a.month8-b.month8,a.month9-b.month9,a.month10-b.month10,a.month11-b.month11,a.month12-b.month12,a.lastYear-b.lastYear,a.qianYear-b.qianYear,'','','','',0, a.sumqty-b.sumqty
from GouJinZiZhiTongJiTable2 a,GouJinZiZhiTongJiTable2 b
where  a.pm='折合标准张合计' and b.pm='Total'