请教一句SQL语句的写法！谢谢！

[coolrit]

比如一个表

A B C

1 5 6
2 5 6
1 5 6
1 5 6
1 5 6
2 5 6

怎么写sql可以查出Ａ的每一个值在表中的列数，A的值不确定．

[antoversky]

你指的是A值出现的次数吗?

[TaoGeGe]

create table #aa(A varchar(1),B varchar(1),C varchar(1))
insert into #aa values (1, 5, 6)
insert into #aa values (2 , 5, 6)
insert into #aa values (1 , 5, 6)
insert into #aa values (1, 5, 6)
insert into #aa values (1, 5, 6)
insert into #aa values (2, 5, 6)
select * from #aa

select count(a) from #aa
group by a

[txlicenhe]

Select A,count(*) as 次数 from 表 group by A

[TaoGeGe]

看看是不是這樣的？

[cysh]

select a,count(*) as '出现次数' from 表 group by a

[txlicenhe]

Select A,count(*) as 次数 from 表 group by A

[伍子V5]

select A,count(*) from tablename group by A

[zjcxc]

select a,次数=sum(1) from 一个表 group by a

[yoki]

Select A,count(*) as 次数 from 表 group by A

[coolrit]

谢谢大家了！！！：）

[coolrit]

可不可以
select A,count(*) as　次数 from 表 where 次数>10 group by A

[coolrit]

怎么出上面的结果当中选出，
出现次数大于一个值的行呢？

[jiandanyu]

select A,count(*) as　次数 from 表 where 次数>10 group by A
having count(*)>10

[Wally_wu]

select A, Count(A) as 列数 from table1 group by A

[jiandanyu]

select A,count(*) as　次数 from 表 group by A
having count(*)>10