mysql - 选择按消费金额排序的前 10 名用户

Question

所以我有一个如下表：

|     steamid | payment_amount |
       199  5.00
       501  10.00
       199  15.00
       238  5.00
       238  1.00

期望的输出：

 199 20.00
 501 10.00
 238 6.00

我试图选择数据，按 steamid 和 payment_amount 的总和分组，但它没有按预期出现？

例如：

SELECT steamid, sum(payment_amount) AS total FROM payments GROUP BY steamid

标签： mysql

Answer 1

SELECT steamid, SUM(payment_amount) AS total FROM payments GROUP BY steamid ORDER BY total DESC

您可以通过添加 order by total desc 如上述查询中所述，通过对查询进行微小更改来获得结果。