php - 排行榜 - MySQL 按个人总和排序

Question

我有一个包含以下列的表格:

+----+--------+-----+------+-------+-------+-------+
| Id | Member | End | Done | Right | Wrong | Score |
+----+--------+-----+------+-------+-------+-------+

每个成员(member)都有多个条目。

我想选择一些(二十)行，按每个成员(member)分数的 SUM() 排序。

我尝试过这个:

SELECT * FROM Challenge ORDER BY SUM(Score) LIMIT 20;

Answer 1

您想要GROUP BY然后您可以SUM每个成员的分数。此查询执行您想要的操作(按第二个字段 - 总和 - 按 DESC 顺序排序)

SELECT Member, SUM(Score) 
FROM Challenge 
GROUP BY Member
ORDER BY 2 DESC 
LIMIT 20