mysql - 我如何退回按城市销售的最大产品？

Question

我有按城市销售的产品，如何退回按城市销售的最大产品？

这是我的查询:

我对每种产品的数量进行了总和，以获得按产品的数量的单一值。

select
product,
sum(qty_city_o) as qty_o,
sum(qty_city_t) as qty_t,
sum(qty_city_th) as qty_th
FROM products
GROUP BY product

Answer 1

您必须将每个城市作为单独的查询来执行。像这样的东西:

SELECT qty_city_o, COUNT(product) FROM products GROUP BY qty_city_o ORDER BY COUNT(product) DESC LIMIT 1