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 学到了!