select A,B from RLB
創(chuàng)新互聯(lián)公司主營(yíng)高坪網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營(yíng)網(wǎng)站建設(shè)方案,App定制開(kāi)發(fā),高坪h5微信小程序搭建,高坪網(wǎng)站營(yíng)銷推廣歡迎高坪等地區(qū)企業(yè)咨詢
union all
select '總計(jì)',sum(B) from RLB
這里A是名字，然后B是你需要匯總的列，表名字是RLB。
MySQL的常見(jiàn)操作在這里先做一下總結(jié)，已經(jīng)整合到代碼里面，經(jīng)過(guò)檢驗(yàn)無(wú)誤。
復(fù)制代碼
代碼如下:
/*創(chuàng)建一個(gè)數(shù)據(jù)庫(kù)*/
create
database
xuning_test;
/*說(shuō)明當(dāng)時(shí)使用數(shù)據(jù)庫(kù)對(duì)象*/
use
xuning_test;
/*向數(shù)據(jù)庫(kù)中添加表并且定義表的結(jié)構(gòu)*/
create
table
person(
id
int
not
null,
name
varchar(16)
not
null,
sex
varchar(16)
not
null,
age
int
not
null,
address
varchar(128)
not
null,
remark
varchar(512)
not
null
);
/*向數(shù)據(jù)庫(kù)的表中插入數(shù)據(jù)*/
insert
into
person
value
(1,'name_1','men',99,'beijing','This
is
a
frindsheep
boy'),
(2,'name_2','men',88,'shanghai','ok
great'),
(1,'name_3','man',77,'guangzhou','This
is
lickly'),
(1,'name_4','men',66,'beijing','This
is
a
frindsheep
boy'),
(1,'name_5','men',55,'beijing','you
dont
going
to
shool'),
(1,'name_6','man',44,'beijing','This
is
a
frindsheep
boy'),
(1,'name_7','men',33,'beijing','This
is
a
frindsheep
boy'),
(1,'name_8','man',22,'beijing',''),
(1,'name_9','men',11,'beijing','This
is
a
frindsheep
boy')
;
/*查詢時(shí)否成功插入*/
select
*
from
person;
/*下面是多種查詢方式*/
/*根據(jù)列的名稱屬性值*/
select
name
from
person;
/*添加條件-根據(jù)性別*/
select
name
from
person
where
sex
=
'men';
/*也可以用比較符作為條件--一定逗號(hào)隔開(kāi)*/
select
name,address
from
person
where
age
50;
/*看做對(duì)象去使用數(shù)據(jù)庫(kù)和表的關(guān)系=---雙表關(guān)聯(lián)--對(duì)象關(guān)系一定要明確*/
select
xuning_test.person.name,
xuning_test.person.id,
xuning_test.person.age,
xuning_test.person.address
from
xuning_test.person,
test1.test_xuning
where
xuning_test.person.id
=
test1.test_xuning.id
;
/*使用表的別名進(jìn)行查詢*/
use
xuning_test;
select
c.name,sex
from
person
as
c
where
c.age
40
and
c.address='beijing';
用mssql的sql angent服務(wù)設(shè)置定時(shí)任務(wù)，將匯總語(yǔ)句寫(xiě)入到任務(wù)的過(guò)程里邊即可。
select 商品名稱,
sum(數(shù)量) as 總量,sum(金額) as 總金額,
sum(case 線號(hào) when '1號(hào)線' then 數(shù)量 else 0 end) as 1號(hào)線數(shù)量,
sum(case 線號(hào) when '2號(hào)線' then 數(shù)量 else 0 end) as 2號(hào)線數(shù)量,
sum(case 線號(hào) when '3號(hào)線' then 數(shù)量 else 0 end) as 3號(hào)線數(shù)量,
sum(case 線號(hào) when '4號(hào)線' then 數(shù)量 else 0 end) as 4號(hào)線數(shù)量,
sum(case 線號(hào) when '1號(hào)線' then 金額 else 0 end) as 1號(hào)線金額,
sum(case 線號(hào) when '2號(hào)線' then 金額 else 0 end) as 2號(hào)線金額,
sum(case 線號(hào) when '3號(hào)線' then 金額 else 0 end) as 3號(hào)線金額,
sum(case 線號(hào) when '4號(hào)線' then 金額 else 0 end) as 4號(hào)線金額
from
(
select 商品名稱,線號(hào),sum(數(shù)量) as 數(shù)量,sum(金額) as 金額
from Table1
group by 商品名稱,線號(hào)
) T1
group by 商品名稱
你后面加一個(gè)group by就行了
select count(*) 人數(shù),健康情況 from PERSON group by 健康情況
有時(shí)對(duì)數(shù)據(jù)表的操作不是表中數(shù)據(jù)本身，而是表中數(shù)據(jù)的匯總，例如
某一列數(shù)據(jù)的平均值，最大值，最小值等。而對(duì)于這些常用的數(shù)據(jù)匯總處理，MySQL提供了函數(shù)來(lái)處理。
SQL聚集函數(shù)
函數(shù)
說(shuō)明
COUNT()
返回某列的行數(shù)
MAX()
返回某列最大值
MIN()
返回某列最小值
AVG()
返回某列平均值
SUM()
返回某列值之和
重慶分公司
重慶分公司
