A. sql count 多表總數求和問題
可以這樣寫:
select
(select count(*) from bumen)+(select count(*) from mrs) as sum_count
如果兩個表結果相同的話,也可以用
select count(*) as sum_count
from
(
select * from A
union all
select * from B
) as tmp
B. 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.客戶ID,c.項目ID,c.該項目總的合同數量,c.該項目總的完成數量,d.其他欄位
from
(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 ) c,tb1 d
where
c.客戶ID=d.客戶ID
C. sql 查詢多張表的分數總和
Oracle中有rank函數，可以這樣寫：SQL> create table zz_ch_mainboard (name varchar2(8),subject varchar2(16),price number);
Table created
SQL> insert into zz_ch_mainboard values ('張三','主板',10);
1 row inserted
SQL> insert into zz_ch_mainboard values ('李四','主板',7);
1 row inserted
SQL> insert into zz_ch_mainboard values ('王五','主板',6);
1 row inserted
SQL> insert into zz_ch_mainboard values ('王五','主板',5);
1 row inserted
SQL> commit;
Commit complete
SQL> create table zz_ch_ems (name varchar2(8),subject varchar2(16),price number);
Table created
SQL> insert into zz_ch_ems values ('張三', '內存', 10);
1 row inserted
SQL> insert into zz_ch_ems values ('李四', '內存', 7);
1 row inserted
SQL> insert into zz_ch_ems values ('王五', '內存', 5);
1 row inserted
SQL> insert into zz_ch_ems values ('張三', '內存', 10);
1 row inserted
SQL> commit;
Commit complete
SQL>
SQL> select name,sum(price) tp,rank() over (order by sum(price) desc) rk from
2 (select name,price from zz_ch_mainboard union all select name,price from zz_ch_ems)
3 group by name;
NAME TP RK
-------- ---------- ----------
張三 30 1
王五 16 2
李四 14 3
D. SQL 多表關聯求和
你的例子中，表3是什麼意思？求誰的和，數量？金額？
對客戶經理=222，品牌編碼=1111的數量、金額求和語句如下：
select 客戶經理,品牌編碼,sum(數量),sum(金額) from 表1 x,表2 y
where x.客戶編碼=y.客戶編碼 and 客戶經理='222' and 品牌編碼='1111'
group by 客戶經理,品牌編碼;
E. SQL里邊的求和語句怎麼寫
用select sum(列名),sum(列名),sum(列名)…… from 表 where 條件。
F. sql 多表關聯 求和語句 怎麼寫
你結果顯示有問題吧，最後id=2怎麼來的？
創建表：
createtabletable1
(idint,
類別varchar(10),
貨號varchar(3))
insertintotable1values(1,'電子','011')
insertintotable1values(2,'零件','022')
insertintotable1values(3,'主板','033')
createtabletable2
(idint,
貨號varchar(3),
數量int)
insertintotable2values(1,'011',5)
insertintotable2values(2,'022',6)
insertintotable2values(3,'033',-8)
insertintotable2values(4,'011',22)
insertintotable2values(5,'022',65)
insertintotable2values(6,'033',81)
查詢：
selecta.id,a.類別,a.貨號,SUM(b.數量)
fromtable1a,table2bwherea.貨號=b.貨號anda.貨號='011'
groupbya.id,a.類別,a.貨號
結果：
G. 求問：sql中多表關聯查詢求和，主表的數據根據副表的數據重復相加了，等於數據翻倍，這種請怎麼處理
首先，我懷疑你or沒用明白，該括弧括起來的地方沒括起來。
然後，你可以先把a表和d表分別匯總，然後再關聯起來。
selectsum(d.go),sum(a.letter1),a.region_id1,d.region_id
from
(selectregion_id1,platform_id1,time1,sum(a.letter1)letter1fromdwdswhere`time1`_id1,platform_id1,time1)a
rightjoin
(selectregion_id,platform_id,time,sum(go)gofrompowerwheretime_id,platform_id,time)d
ONd.platform_id=a.platform_id1ANDd.time=a.time1
groupbya.region_id1,d.region_id
另外，你a.region_id1和d.region_id是相等的，你select里都查出來幹嘛？
H. sql 多表查詢求和
建表a（插入數據過程略）
create table a
(mingzi varchar2(50),
id int);
I. SQL如何統計多表總記錄數
有2個方法：
1、select
*,(select
count(u_id)
from
h_travel_line
where
u_id
=
a.u_id)
已線路數
from
h_travel
a
2、SELECT
c.ttt
AS
已線路數,
h_travel.*
FROM
h_travel
INNER
JOIN
(SELECT
COUNT(*)
AS
ttt,
u_id
FROM
h_travel_line
GROUP
BY
STID)
c
ON
h_travel.u_id
=c.u_id
J. sql server 多表之間求和
--假設JE_EmpID就是員工ID的話，統計的語句如下
selectJE_EmpID,SUM(JE_JiFen)asJE_JiFenfrom
(
selectJE_EmpID,JE_JiFenfromJF_'2015-01-01'and'2015-01-31'
unionall
selectJE_EmpID,JE_JiFenfromJF_OnLinewhereCreateTimebetween'2015-01-01'and'2015-01-31'
……
)t1groupbyJE_EmpID