SQL语句查询重复次数最多的记录

Question

这是我执行完这条语句的结果
SELECT COUNT(user_id) as user_count,user_id as uid from history_copy GROUP BY user_id

这是执行完这条语句的结果
SELECT MAX(t.user_count),t.uid from
(SELECT COUNT(user_id) as user_count,user_id as uid from history_copy GROUP BY user_id ) t;
请问逻辑有什么不对呢

Answer 1

第二条sql语法不对，你要取数量最多的那条记录应该排序之后取第一条。