查询语句

[busanbusi]

我建了一个电话簿表，我想查出每个号码出现的次数。查询的结果中列出号码与次数，怎么做啊？请教了

[lynx1111]

select haoma,count(cishu) from t1 group by haoma

[new_life]

select haoma,count(*) from t1 group by haoma

[busanbusi]

select 电话号码，count(*) from 电话簿 a where (select count(*) from 电话簿 where 电话号码=a.电话号码)=1 group by 电话号码


select 电话号码，count(*) from 电话簿 a where (select count(*) from 电话簿 b where b.电话号码=a.电话号码)=2 group by 电话号码
select 电话号码，count(*) from 电话簿 a where (select count(*) from 电话簿 b where b.电话号码=a.电话号码)>3 group by 电话号码
这些语句错在哪呀？谁帮我看看？

[LoveSQL]

使用having
select 电话号码，count(*) from 电话簿 a where group by 电话号码 having count(*) =1
select 电话号码，count(*) from 电话簿 a where group by 电话号码 having count(*) =2
select 电话号码，count(*) from 电话簿 a where group by 电话号码 having count(*)>3