select 品种,sum(数量) as 数量 from 表1 group by 品种 这样????
select 品种,sum(数量) from talbe group by 品种 order by 品种
select 品种,sum(数量) as 数量 from 表名 group by 品种
select 品种,sum(数量) as 数量 from table group by 品种
select 品种,sum(数量) from talbe1 group by 品种 order by 品种
-- 品种 数量 -- a 6 -- b 3 -- c 4 -- a 5 -- b 4--要求结果为 -- 品种 数量 -- a 11 -- b 7 -- c 4 create table csdnTest ( [pingzhong] nvarchar(20) null, [shuliang] int null ) --insert into csdnTest values('a',6) --insert into csdnTest values('b',3) --insert into csdnTest values('c',4) --insert into csdnTest values('a',5) --insert into csdnTest values('b',4) SELECT distinct(pingzhong),sum(shuliang) as countType FROM csdnTest GROUP BY pingzhongpingzhong countType -------------------- ----------- a 11 b 7 c 4(3 行受影响)
from 表1
group by 品种
这样????
from talbe
group by 品种
order by 品种
-- 品种 数量
-- a 6
-- b 3
-- c 4
-- a 5
-- b 4--要求结果为
-- 品种 数量
-- a 11
-- b 7
-- c 4
create table csdnTest
(
[pingzhong] nvarchar(20) null,
[shuliang] int null
)
--insert into csdnTest values('a',6)
--insert into csdnTest values('b',3)
--insert into csdnTest values('c',4)
--insert into csdnTest values('a',5)
--insert into csdnTest values('b',4)
SELECT distinct(pingzhong),sum(shuliang) as countType FROM csdnTest GROUP BY pingzhongpingzhong countType
-------------------- -----------
a 11
b 7
c 4(3 行受影响)