弱弱求一个sql语句

[devilli]

表结构如下name1 num（数量） price(单价)
a 2 1
b 1 2
c 4 3
a 1 1
d 5 4
e 3 5
b 1 2
d 1 4
a 1 1
想查a\b\c\d\e\后面对应数字的和
如 name1 allnum数量和 allprice（总金额）
a 4 4
b 2 4
c 4 12
d 6 24
e 3 15

[chuifengde]

select name1,sum(num) allnum,sum(price) allprice from [Table] group by name1

[liangCK]

select name1,sum(num) allnum,sum(price) allprice from [Table] group by name1

[pt1314917]

--> 测试数据: @s
declare @s table (name1 varchar(1),num int,price int)
insert into @s
select 'a',2,1 union all
select 'b',1,2 union all
select 'c',4,3 union all
select 'a',1,1 union all
select 'd',5,4 union all
select 'e',3,5 union all
select 'b',1,2 union all
select 'd',1,4 union all
select 'a',1,1

select name1,allnum=sum(num),allprice=sum(price*num) from @s group by name1

[zjcxc]

SELECT
    name1,
    allnum = SUM(num),
    allprice = SUM(price)
FROM 表
GROUP BY name1

[dlpseeyou]

select name1,sum(num),sum(price) from table group by name1

[昵称被占用了]

select name1,sum(num) as allnum,sum(num*price) as allprice
from tab
group by name1

[Garnett_KG]

SELECT  name1,
        allnum=SUM(num),
        allprice=SUM(price)
FROM    tbname
GROUP BY name1

[linux_ch]

select name sum(num),sum(price1) from ta group by name1

[devilli]

allprice（总金额）＝allnum（总数量） × price（单价）呢

[liangCK]

[Quote=引用 5 楼 Haiwer 的回复:]
SQL codeselect name1,sum(num) as allnum,sum(num*price) as allprice
from tab
group by name1
[/Quote]

[jiang5311]

用group by语句就可以了

[wer123q]

select name1,sum(num) allnum,sum(price) allprice from [Table] group by name1

[-晴天]

单价还有求和的???

select name sum(num) as allnum,sum(num*price1) as allprice from ta group by name1

[-晴天]

select name, sum(num) as allnum,sum(num*price) as allprice from ta group by name1

[wxg22526451]

select name, sum(num) as allnum,sum(num*price) as allprice from ta group by name1

[zengxianggc]

select name name1,sum(num) allnum,sum(price) allprice
from table
group by name

[beckham2537]

人家明白的写的总额：
select name1,sum(num) allnum,sum(price*num) allprice from [Table] group by name1

[Dragon_pan]

--> 测试数据: @s
declare @s table (name1 varchar(1),num int,price int)
insert into @s
select 'a',2,1 union all
select 'b',1,2 union all
select 'c',4,3 union all
select 'a',1,1 union all
select 'd',5,4 union all
select 'e',3,5 union all
select 'b',1,2 union all
select 'd',1,4 union all
select 'a',1,1

select name1,allnum=sum(num),allprice=sum(price*num) from @s group by name1

[scy251147]

mark