mysql - 为什么这会给我错误的 customerNumber？

Question

我试图让客户支付最高金额。它给了我最大的金额，但找错了客户。我该怎么办？

SELECT temp.customerNumber, MAX( temp.max ) AS sum
FROM (
    SELECT p.customerNumber, p.amount AS max
    FROM payments p
    GROUP BY p.customerNumber
) AS temp

Answer 1

我认为您不需要这里的子查询:

SELECT p.customerNumber, MAX(p.amount) AS max
FROM payments p
GROUP BY p.customerNumber
ORDER BY max DESC
LIMIT 1