想知道 php 这个职位哪些技能关键词出现频率最高 采集完了 X 钩的 php 招聘信息 有个 sql 统计语句不懂写来求助

得到的结果是
keyword count
oop 999
mysql 800
接口 100

其实就是N多个语句拼成一句来写
SELECT count(*) FROM `table` where `keyword` = 'oop'
SELECT count(*) FROM `table` where `keyword` = 'mysql'
SELECT count(*) FROM `table` where `keyword` = '接口'
。。。

按照各自得出的count数量降序排列

GROUP BY

```sql
select keyword, count(*) as c from table group by keyword order by c desc
```

SELECT count(*) as count FROM table GROUP BY keyword ORDER BY count DESC

@binjoo
@mhycy
感谢两位
可以看看这个帖子
t/175821