本文共 337 字，大约阅读时间需要 1 分钟。

题目链接：

题目大意：略。

解题思路：解决方案(2)比解决方案(1)更优雅，是因为对 ORDER BY 和 GROUP BY 的理解执行顺序没到位。

AC 代码

-- 解决方案(1)SELECT customer_numberFROM (SELECT customer_number, COUNT(customer_number) cnt FROM ordersGROUP BY customer_number) RSORDER BY cnt DESCLIMIT 1;-- 解决方案(2)SELECT    customer_numberFROM    ordersGROUP BY customer_numberORDER BY COUNT(*) DESCLIMIT 1;

转载地址：https://lux-sun.blog.csdn.net/article/details/117711302 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！