mysql - 按 SUM MYSQL 显示/选择和排序

Question

我有这个数据

ID | Name | views
1  | one  | 10
2  | one  | 10
3  | three| 30
4  | four | 5
5  | four | 5

我如何显示 orderby 的总和？

像这样输出

three  | 30
one    | 20
four   | 10

标签： mysql

Answer 1

您可以使用下一个简单查询：

SELECT
  `Name`, SUM(Views) `TotalViews` 
FROM `Data` 
GROUP BY `Name` 
ORDER BY `TotalViews` DESC;

这里的例子SQLize.online