mysql - 如何获得不重复的用户总数？

Question

我有表付款，我需要获得总用户数限制为 3

SELECT SUM(money),username FROM `payments` ORDER BY money DESC LIMIT 3

表格:

+----------+--------+
| username | money  |
+----------+--------+
| Alex     | 200    |
+----------+--------+
| Alex     | 100    |
+----------+--------+
| John     | 50     |
+----------+--------+
| Emily    | 400    |
+----------+--------+
| etc ...

我怎样才能得到这个结果？ :

+----------+--------+
| username | amount |
+----------+--------+
| Emily    | 400    |
+----------+--------+
| Alex     | 300    |
+----------+--------+
| John     | 50     |
+----------+--------+

Answer 1

因为您需要用户明智的总计，所以您必须添加 group by 子句

您可以在下面尝试 - 您需要添加group by clause

SELECT username, SUM(money) AS amount
FROM payments
GROUP BY username
ORDER BY amount DESC
LIMIT 3;