php - 找到出现次数最多的值并按其排序

Question

+-----------------------+------------------------+
| being_followed        | follower               |
+-----------------------+------------------------+
| Bob Dylan             |                      B |
| Bob Dylan             |                      A |
| Sam Cooke             |                      X |
| The Beatles           |                      Y |
| Bob Dylan             |                      M |
| Sam Cooke             |                      N |
+-----------------------+------------------------+

现在，我想找到 being_followed 中出现次数最多的值，然后按它排序。 它应该看起来有点像 -

Bob Dylan - 3
Sam Cooke - 2
The Beatles - 1

请不要将此标记为重复。

Answer 1

尝试以下:

select being_followed , count(1) as count
from table
group by being_followed 
order by count desc ;