586. 订单最多的国家(*)
https://leetcode.cn/problems/customer-placing-the-largest-number-of-orders/description/
- 分析:最大值-用逆序排序取第一个的方式来计算
- 如果最大值只有一个:
SELECT customer_number FROM orders GROUP BY customer_number ORDER BY COUNT(*) DESC LIMIT 1 ;
- 如果最大值有多个:
select customer_number from Orders group by customer_number having count(customer_number)= ( SELECT COUNT(customer_number) AS 'cnt' FROM Orders GROUP BY customer_number ORDER BY cnt DESC LIMIT 1 )