sql server两行相减

最新推荐文章于 2024-08-01 08:23:29 发布

苦茶折柳

最新推荐文章于 2024-08-01 08:23:29 发布

阅读量1.8k

点赞数

分类专栏： sql server 文章标签：数据库 sql

本文链接：https://blog.csdn.net/weixin_51803498/article/details/127401086

版权

sql server 专栏收录该内容

34 篇文章 0 订阅

订阅专栏

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'