多表联合查询的问题《多表联合查询的问题？

2012-06-14 09:30:11 98 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

goodluck2017 墨衍会员 · AI 创作全网分发关注 + 加入社区

从ISO 17987到SAE J2602：LIN一致性测试标准全景解读与CANoe实现本文深入解析了从ISO 17987到SAE J2602的LIN一致性测试标准技术演进，详细对比了两大标准体系的技术差异，并基于Vector CANoe平台演示了如何构建符合最新行业要求的自动化测试方案。文章重点介绍了SAE J2602标准的三大改进点，包括唤醒特性、传输层协议和诊断服务的增强测试要求，并提供了CANoe测试环境配置、测试模块集成及测试案例解析的实战指南。阅读详情

select a.corp_id,a.corp_name,(select sum(b.sale_money) from x_sale sale_corp=a.corp_id)as salemoney,(select sum(b.saleout_money) from x_saleout saleout_corp=a.corp_id)as saleoutmoney,这里怎么写才可以salemoney和saleoutmoney 相减 from x_kcorp a

...全文

python怎样按某一列值拆分Excel表格 pd.ExcelWriter@python #用python按某一列拆分Excel工作表，将内容写入一个工作簿本次以“按照表中的某一列，将一张表格拆分为多张表”的需求为例，简单介绍这个过程中用到的pd.ExcelWriter，及每一句的作用。如上表《学生.xlsx》，假设有14万行28列，请按照学校名，拆分表格（不想用复制粘贴）。 ##代码及解释如下 import pandas as pd from time import time#用来计算时间，展示进度，减少焦虑 in_ws='学生.xlsx'# 阅读详情

goodluck2017

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

百年树人 2012-06-14

打赏
举报

select  

  *,

  diff = salemoney - saleoutmoney

from

(

  select  

  a.corp_id,

  a.corp_name,

  (select sum(b.sale_money) from x_sale where sale_corp=a.corp_id) as salemoney,

  (select sum(b.saleout_money) from x_saleout where saleout_corp=a.corp_id) as saleoutmoney

  from x_kcorp a

) T

where salemoney - saleoutmoney!=0

goodluck2017 2012-06-14

打赏
举报

select
*,
diff = salemoney - saleoutmoney
from
(
select
a.corp_id,
a.corp_name,
(select sum(b.sale_money) from x_sale where sale_corp=a.corp_id) as salemoney,
(select sum(b.saleout_money) from x_saleout where saleout_corp=a.corp_id) as saleoutmoney
from x_kcorp a
) T
如何去掉realmoney为零的记录

百年树人 2012-06-14

打赏
举报

[Quote=引用 5 楼的回复:]
如果去掉diff = salemoney - saleoutmoney 为0的记录
[/Quote]

select 

  a.corp_id,

  a.corp_name,

  b.salemoney,

  c.saleoutmoney,

  b.salemoney-c.saleoutmoney as diff

from x_kcorp a

join (select sale_corp,sum(sale_money) as salemoney from x_sale group by sale_corp) b

  on a.corp_id=b.sale_corp

join (select saleout_corp,sum(saleout_money) as saleoutmoney from x_saleout group by saleout_corp) c

  on a.a.corp_id=c.saleout_corp

where b.salemoney-c.saleoutmoney!=0

goodluck2017 2012-06-14

打赏
举报

如果去掉diff = salemoney - saleoutmoney 为0的记录

百年树人 2012-06-14

打赏
举报

[Quote=引用 3 楼的回复:]
谢谢大家，如果还要用diff = salemoney - saleoutmoney的值当子查询，如
gmoney=diff*100,应该如何写
[/Quote]
参考1楼，直接(b.salemoney-c.saleoutmoney)*100

goodluck2017 2012-06-14

打赏
举报

谢谢大家，如果还要用diff = salemoney - saleoutmoney的值当子查询，如
gmoney=diff*100,应该如何写

Shawn 2012-06-14

打赏
举报

use CSDN

go



--#1.直接减就可以

select 

	a.corp_id,

	a.corp_name,

	(select sum(b.sale_money) from x_sale where sale_corp=a.corp_id) as salemoney,

	(select sum(b.saleout_money) from x_saleout where saleout_corp=a.corp_id) as saleoutmoney,

	diff = (select sum(b.sale_money) from x_sale where sale_corp=a.corp_id) - (select sum(b.saleout_money) from x_saleout where saleout_corp=a.corp_id)

from x_kcorp a



--#2.或者用子查询

select 

	*,

	diff = salemoney - saleoutmoney

from

(

	select 

		a.corp_id,

		a.corp_name,

		(select sum(b.sale_money) from x_sale where sale_corp=a.corp_id) as salemoney,

		(select sum(b.saleout_money) from x_saleout where saleout_corp=a.corp_id) as saleoutmoney

	from x_kcorp a

) T

百年树人 2012-06-14

打赏
举报

select 

  a.corp_id,

  a.corp_name,

  b.salemoney,

  c.saleoutmoney,

  b.salemoney-c.saleoutmoney

from x_kcorp a

join (select sale_corp,sum(sale_money) as salemoney from x_sale group by sale_corp) b

  on a.corp_id=b.sale_corp

join (select saleout_corp,sum(saleout_money) as saleoutmoney from x_saleout group by saleout_corp) c

  on a.a.corp_id=c.saleout_corp

多表联合查询的问题《多表联合查询的问题？

相关推荐