mysql - 我想获得访问量最大的 5 个部分 desc 订购

Question

假设我有这个 MySql 表结构

+----+------------+-------+
| id | section_id | views |
+----+------------+-------+
|  1 |      2     |   15  |
+----+------------+-------+
|  2 |      2     |   12  |
+----+------------+-------+
|  3 |      1     |   15  |
+----+------------+-------+
|  4 |      3     |   60  |
+----+------------+-------+
|  5 |      2     |  100  |
+----+------------+-------+
|  6 |      2     |   20  |
+----+------------+-------+
|  7 |      4     |   14  |
+----+------------+-------+
|  8 |      5     |   60  |
+----+------------+-------+
|  9 |      6     |   12  |
+----+------------+-------+
| 10 |      1     |   17  |
+----+------------+-------+

我想获得访问量最大的 5 个部分描述

我已经尝试过 SELECT section_id FROM my_table ORDER by VIEWS DESC LIMIT 5 并尝试过一些其他的东西，比如 sum() 但最后我感到困惑，因为我还没有长期使用MySql

非常感谢您的帮助

Answer 1

SQL:

  SELECT section_id, SUM(views)
    FROM my_table
GROUP BY section_id
ORDER BY SUM(views) DESC
   LIMIT 5

结果:

section_id  sum(views)
2           147
3           60
5           60
1           32
4           14

Playground :

http://sqlfiddle.com/#!9/6e3266/3/0