❶ sql根据ID，对两个表中的字段求和
--同一ID的”数值字段1的总和“、”数值字段2的总和“
selectID,SUM(数值字段1)AS数值字段1的总和,SUM(数值字段2)AS数值字段2的总和
FROM(
selectID,数值字段1,0as数值字段2from表1
unionall
selectID,0as数值字段1,数值字段2from表2)TGROUPBYID
--所有ID的”数值字段1的总和“、”数值字段2的总和“
selectSUM(数值字段1)AS数值字段1的总和,SUM(数值字段2)AS数值字段2的总和
FROM(
selectID,数值字段1,0as数值字段2from表1
unionall
selectID,0as数值字段1,数值字段2from表2)T
❷ SQL两个表求和语句用什么。
select 表1.地方 as 地方,表1.一月金额+表2.二月金额 as 总金额
from 表1，表2
where 表1.地方=表2.地方
修改后如下这个比较合理：
select 表1.地方,一月金额+二月金额 as 总金额
from 表1 ,表2
where 表1.地方=表2.地方
union
select '总金额',sum(一月金额+二月金额)
from 表1 ,表2
where 表1.地方=表2.地方
❸ sql 分组求和 同时满足2个条件，再把求和结果相加
用 union 做多查询连接
SELECT A, SUM(real_qty) AS qiuhe, B
FROM AA
GROUP BY A, B
HAVING (B = '小明')
ORDER BY item_barcode
union
SELECT A, SUM(real_qty) AS qiuhe, B
FROM AA
GROUP BY A, B
HAVING (B = '小 花')
ORDER BY item_barcode
union
SELECT ''as a, SUM(real_qty) AS qiuhe, '' as b
FROM AA
GROUP BY A, B
❹ 求一个两表多条件查询求和的SQL语句
SELECT 序号, SUM(金额)
FROM 表2
WHERE 类型='大'
AND EXISTS(SELECT 1 FROM 表1 WHERE 序号 = 表2.序号 AND 时间 BETWEEN '2010/1/1' AND '2010/12/31'
GROUP BY 序号
between那里可以用年份判断更快点，YEAR(时间) = 2010
❺ SQL求和，要怎么写内容如下
select sum (提供房源总抽成数) as 提供房源总抽成数 from (
select sum(cast(pumped1 as int))as 提供房源总抽成数 from Sold where stano1='02'
union all
select sum(cast(pumped2 as int))as 提供客源总抽成数 from Sold where stano2='02'
) ta
❻ SQL语句两个表的查找求和
select
表1.地方
as
地方,表1.一月金额+表2.二月金额
as
总金额
from
表1，表2
where
表1.地方=表2.地方
修改后如下这个比较合理：
select
表1.地方,一月金额+二月金额
as
总金额
from
表1
,表2
where
表1.地方=表2.地方
union
select
'总金额',sum(一月金额+二月金额)
from
表1
,表2
where
表1.地方=表2.地方
❼ sql求和问题
withtmp(用户名,当前积分,期号)
as
(
select1,5,1unionall
select1,6,2unionall
select1,7,3unionall
select2,1,1unionall
select2,2,2unionall
select1,8,4
)
selectSUM(当前积分)as积分合计
from(selectt.*,
ROW_NUMBER()over(partitionby用户名orderby期号desc)rn
fromtmpt)t1
wheret1.rn=1
❽ 求SQL里实现一个多级求和的例子
select Sum(A.金额),Sum(B.金额) from A,B where A.关联列名=B.关联列名
里边对应的列名和关联的列名自己填上自己填上~
说清楚一点~