拜求一SQL

[hnnxzhoujia]

现有表 TS_M

PHONE KEYWD TIME
13811112222 1111 a
13811113333 1111 b
13811114444 1111 d
13811112222 2222 c
13811112222 1111 t
13811112222 1111 r


目前界面要求展现
手机号码 关键字 统计次数
13811112222 1111 3
2222 1

13811113333 1111 1

13811114444 1111 1

拜求SQL

[shine333]

select PHONE, min(KEYWD), count(*) from TS_M group by PHONE

[chenzhuomin]

select PHONE as 手机号码, KEYWD as 关键字, count(*) as 统计次数
from TS_M
group by PHONE ,KEYWD

[wutian4567268]

select PHONE as '手机号码',KEYWD as '关键字',count(1)as '统计次数' from TS_M
group by PHONE,KEYWD
order by PHONE,KEYWD

[hnnxzhoujia]

不对啊。查询结果不对KEYWD不一定是数字，字符串

[crazylaa]

select phone,keywd,count(1) amount from ts_m group by phone,keywd order by phone,amount desc;

[sweetBug]

按PHONE与KEYWD分组，楼上正解

[ZHXDD]

select phone,keywd,count(phone)as c from ts_m group by phone,keywd;