怎样快速统计一个表中的内容(100分)

E

EAST

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-05-18

• #1

一字段中有N个不同的值(未知值的个数),如何统计不同值的记录个数?

 

小

小天

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-05-18

• #2

select count(distinct fieldname) from tablename

 

E

EAST

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-05-18

• #3

对不起!!是字段中值,不是字段的个数

 

D

DSM2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-05-18

• #4

select count(*) ,fieldname from table group by fieldname

 

Z

zensst

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-05-18

• #5

select count(FieldName) ,FieldName from TableName group by FieldName

返回 值的个数，值

 

P

popeye

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-05-18

• #6

要用group by

 

T

Tianhao

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-05-18

• #7

select distinct count(*) from table group by fieldname

 

E

EAST

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-05-19

• #8

接受答案了.