求一句SQL关于计算合计(50分)

少

少爷的拐杖

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-03

• #1

表内容如下
编号 名称 金额
1 a 12.0
1 a 20.5
1 a 2.45
2 b 10.2
2 b 4.5
3 c 1.02
。。。。。

得到
1 a 34.95
2 b 14.7
3 c 1.02
。。。。。
怎么做？

 

X

xianguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-03

• #2

SELECT 编号,名称,SUM(金额) FROM Table
GROUP BY 编号,名称

 

T

terrydelphi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-03

• #3

Select 编号,名称,Sum(金额) as 金额 From 表
Group By 编号,名称
Order By 编号,名称

 

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-03

• #4

select name,count(jine) as CC
from Biao
Group by name
order by CC

 

B

breezee

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-03

• #5

太简单了吧：）

 

X

xzh2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-03

• #6

create table a1(id int,name varchar(20),qty tinyint)
insert into a1 values(1,'abc',20)
insert into a1 values(1,'abc',30)
insert into a1 values(2,'abd',20)
insert into a1 values(2,'abd',30)

select id,name,sum(qty) from a1 group by id,name

 

C

Carson_zzd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-03

• #7

Select 编号,名称,Sum(金额) as 金额
from tablename
Group By 编号
Order By 编号

 

少

少爷的拐杖

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-03

• #8

问题已解决
最后用SQL管理器里的工具搞定。