统计问题 ( 积分: 50 )

衣

衣雪峰

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-12-03

• #1

数据库记录
zname
xx
xx
xxx
xxx
xxxxx
xxxxx
xxxxx
请问如何计算三种不同名称的数据总和．
显示结果为
zname number
xx 2
xxx 2
xxxxx 3

 

S

s00000000001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-12-04

• #2

select zname, count(1) as number
from tb
group by zname

 

D

duxing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-12-04

• #3

楼上正解~~

 

L

longriver621

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-12-04

• #4

select zname,count(zname) as number from table_name
group by zname

 

L

longriver621

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-12-04

• #5

select zname,count(zname) as number from table_name
group by zname