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