1、题目描述
来源:力扣(LeetCode)
2、解题思路
简单的题目,直接写的进阶解答方式
1# 首先,对customer_number
分组,统计数量
2# 对数量进行排名,参考 178. 分数排名
3# 取排名为1的记录
3、提交记录
select customer_number
from(
select add_cou.*,(@n:=case when @j=(@j:=cou) then @n else @n+1 end) as rank
from(
select customer_number,count(*) as cou
from orders
group by customer_number
) add_cou,(select @n:=0,@j=-1) a
order by cou desc) add_rank
where rank=1
618ms,真吉利