1.此段查询语句返回 article_keyword 表中 keyword 重复次数(count)。
SELECT keyword, count( * ) AS count FROM article_keyword GROUP BY keyword ORDER BY count DESC
2.keyword出现的总次数
SELECT count( distinct keyword ) AS count FROM article_keyword
1.此段查询语句返回 article_keyword 表中 keyword 重复次数(count)。
SELECT keyword, count( * ) AS count FROM article_keyword GROUP BY keyword ORDER BY count DESC
2.keyword出现的总次数
SELECT count( distinct keyword ) AS count FROM article_keyword