- SELECT keyword, count( * ) AS count
- FROM article_keyword
- GROUP BY keyword
- ORDER BY count DESC
- LIMIT 20
此段查询语句返回 article_keyword 表中 keyword 重复次数(count)最多的20条记录。
最新推荐文章于 2021-11-16 17:15:19 发布
- SELECT keyword, count( * ) AS count
- FROM article_keyword
- GROUP BY keyword
- ORDER BY count DESC
- LIMIT 20