SQL 求和语句

SELECT SUM(zy_detail_charge.charge_amount) FROM zy_detail_charge where zy_detail_charge.charge_code in (select fee_code from or_level where or_level = 'xt' and flag = '410')and data_month ='2010-08'SELECT SUM(mz_charge_detail.quantity) from mz_charge_detail where mz_charge_detail.charge_item_code in (select fee_code from or_level where or_level = 'xt' and flag = '410')and data_month ='2010-08' 我要把这两条语句加在一起求和改怎么写求和语句。

举报该问题

其他回答

第1个回答推荐于2017-04-22

select sum(a.a) from
(
SELECT SUM(zy_detail_charge.charge_amount) FROM zy_detail_charge where zy_detail_charge.charge_code in (select fee_code from or_level where or_level = 'xt' and flag = '410')and data_month ='2010-08'
union all
SELECT SUM(mz_charge_detail.quantity) from mz_charge_detail where mz_charge_detail.charge_item_code in (select fee_code from or_level where or_level = 'xt' and flag = '410')and data_month ='2010-08'
) a(a)

第2个回答 2012-03-03

select sum(charge_amount)
from
(
查询A
union all
查询B
)

相似回答

sql语句求和答：SQL中求和语句分为纵向汇总和横向汇总语句；假设数据列为：A、B、C、D、E、F、G 纵向汇总语句：selectsum(A),sum(B),sum(C),sum(D),sum(E),sum(F),sum(G)from表名横向汇总的SQL语句是：selectA,B,C,D,E,F,G,A+B+C+D+E+F+Gfrom表名求所有数据总和的SQL语句是：selectsum(A)...

sql语句怎么查询一列数据的总和答：MS-SQL中求和如下：1、select sum (foamt) from t_ACRD_GthMst 2、select sum (foamt) from t_ACPD_PayMst t_ACRD_GthMst和t_ACPD_PayMst表示某ERP系统中的两个表，foamt表示要求和的一例。

SQL数据库里的求和语句怎么写?答：那么你纵向汇总的SQL语句是：selesum(a),sum(b),sum(c),sum(d),sum(e),sum(f),sum(g) from 表名。求所有数据总和的selectsum(a)+sum(b)+sum(c)+sum(d)+sum(e)+sum(f)+sum(g) from 表名。用select sum(列名),sum(列名),sum(列名)…… from 表 where 条件。SQL（英文全称：...

SQL按条件汇总求和答：1、第一步，将示例表导入SQL语句中，见下图，转到下面的步骤。2、第二步，完成上述步骤后，输入生成代码“SELECT * FROM student WHERE student.name LIKE'％涛涛％'”用于模糊查询，见下图，转到下面的步骤。3、第三步，完成上述步骤后，输入代码“SELECT COUNT（*）FROM student”对总数进行计数，...

sql语句,去重复,求和值答：你好！select sum(k.b) from (select distinct a,b from test) k希望对你有帮助！

sql 分类求和?答：分类求和用sum函数比如：emp中数据如下要按照deptno分组求sal的和，可用下边语句：select deptno,sum(sal) from emp group by deptno;结果如下：

SQL怎么对某一列进行求和并计数?一句sql语句可以写么答：select sum(id4),count(*) from a_temp ;可以一句SQL就直接查询得到列的和以及记录数。该SQL中sum(id4)是列id4的总和，count(*)是得到的数据总行数。

sql对查询结果求和答：select * from pw_memberdata t，4、编写sql语句，select * from (SELECT i.uid, sum(deposit+ddeposit+money) as allmoney FROM pw_memberinfo i LEFT JOIN pw_members m ON m.uid=i.uid LEFT JOIN pw_memberdata d ON i.uid=d.uid group by i.uid ) t where allmoney>200 ...

SQL多个关联表求和语句答：设查询客户ID为'A0001',查询语句如下:select a.客户ID,a.项目ID,sum(a.合同数量) as 该项目总的合同数量,sum(b.完成数量) as 该项目总的完成数量 from tb2 a,tb3 b where a.项目ID=b.项目ID and a.客户ID='A0001'group by a.客户ID,a.项目ID 如果还要包含其他字段:代码如下:select...

大家正在搜

C语言for循环语句求和求和sql语句 sql列求和语句常用sql语句求和 sql求和语句怎么写 sql语句中的sum求和用法 sql语句sum求和查询 sqlserver求和语句 sql语句非整数型求和