SQL语句如何求不同值的个数

[cgd0282]

SELECT COUNT(DISTINCT A)

FROM Table

求出不同A的个数

表table : A B
fd XX
fd jj
gf kk
我现在想要求出A字段fd的有两条,gf的有一条.也就是要结果为:
A count
fd 2
gf 1
有没办法?

[aniude]

create table tb
(
a char(2),
b char(2)
)
insert into tb select 'fd','xx'
union all select 'fd','jj'
union all select 'gf','kk'
select a,[count]=(select count(a) from tb tb2 where tb.a=tb2.a group by a) from tb group by a

[aniude]

a count
---- -----------
fd 2
gf 1

（所影响的行数为 2 行）

[cgd0282]

可以了.

[rivery]

select fd,count(*)
from table
group by A

[rivery]

上面字段写错了。
select A,count(*)
from table
group by A