How to execute this query in MYSQL?

Question

Suppose I have a column with the words:

orange
grape
orange
orange
apple
orange
grape
banana

How to fulfill the request to get the top 10 words, as well as their score?

Answer 1

SELECT word, COUNT(*) word_cnt
FROM your_table
GROUP BY word
ORDER BY COUNT(*) DESC
LIMIT 10

Groups GROUP BYby values word, ORDER BY COUNT(*) DESCfirst get the rows with the highest number, and LIMIT 10returns only the first 10 rows.

Answer 2

SELECT   word, COUNT(*) AS n
FROM     `table`
GROUP BY word
ORDER BY COUNT(*) DESC
LIMIT 10