sql查询，在线等.

表a里有几个字段sendTime,mobileNo,smsContent,smsId.
我希望查出每一个mobileno(手机号),有多少个短信(smsContent).
SQL code:

mobileno smsContent
------------------------
134 我
134 你
134 他
135 你们
146 介


得到数据
mobileno smsContent as sms
--------------------
134 3
135 1
146 1



求解决.在线等.

---

哎，都看国庆去了吗?

---

select mobileno,count(mobileno) as sms group by mobileno

---

select mobileno,count(mobileno) as sms from tbname group by mobileno

---

select mobileno , count( smsContent ) as sms
from table
group by mobileno
order by mobileno

---

SQL code:

create table #tt
(
mobileno int,
smscontent varchar(50)
)
insert into #tt values(134,'我')
insert into #tt values(134,'你')
insert into #tt values(134,'他')
insert into #tt values(135,'你们')
insert into #tt values(146,'介')

select * from #tt
select mobileno,count(*) as sms from #tt group by mobileno