586 订单最多的客户 (1)题目描述 (2)具体实现 # Write your MySQL query statement below # 为下了最多订单的客户查找customer_number:分组+排序+Limit select customer_number from Orders group by customer_number order by count(order_number) desc limit 1 (3)总结 思路与重复数据有点类似,都是以group by为基础,不同在于排序和取固定数量的记录;group by, order by, limit 学到了!