急求：用SQL语句，如何才能实现分类汇总？？？(10分)

M

myjane

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-29

• #1

字段如下：
type shuliang
---------------------------------------
ZWZ3510 10
HRB180206 20
ZWZ3510 50
HRB180206 30
----------------------------------------

我想要查询后得到：
type shuliang
---------------------------------------
ZWZ3510 60
HRB180206 50

 

N

NoSwing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-29

• #2

select type sum(shuliang) from table_name group by type

 

R

rockxu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-29

• #3

select type,sum(shuliang) from table
group by type

 

M

myjane

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-29

• #4

提示from子句错误！！

 

峻

峻祁连

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-29

• #5

同意rockxu,

 

M

myjane

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-29

• #6

多人接受答案了。