34,590
社区成员
发帖
与我相关
我的任务
分享
select top 1 add_user,count(*) as 总条数
from table1
group by add_user
order by 总条数 desc
select top 1 add_user,count(*) as 总条数
from table1
group by add_user
order by 总条数 desc
select top 1 add_user , count(1) cnt from tb group by add_user order by cnt desc