一条简单的sql语言请教

[manica122]

输出再数据库中发送短信超过出现了500次人的手机号码统计
有ID 手机号码 发送的号码 发送时间

[txlicenhe]

Select 手机号码,count(*) from 表 group by 手机号码 having count(*) > 500

[eastpond]

select cc_sum = count(id),手机号码 from table group by id,手机号码 having count(id) > 500;

[CrazyFor]

select 手机号码,count(*) 次数 from 表 group by 手机号码 having count(*)>=500

[LengyuYuan]

select 手机号码
from TableName
group by 手机号码 having count(手机号码)>=500