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

这是我执行完这条语句的结果
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;
请问逻辑有什么不对呢

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

select * from (SELECT updater u,count(1) c FROM  budget_instance_sheet  group by updater )a where a.c=(
select max(c) from (SELECT updater u,count(1) c FROM  budget_instance_sheet  group by updater )b)

你要where