❶ 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.關聯列名
里邊對應的列名和關聯的列名自己填上自己填上~
說清楚一點~