34,590
社区成员
发帖
与我相关
我的任务
分享
select a.*,b.重复次数 from tbName a,(
select top 1 重复字段 as 重复, count(*) as 重复次数
from tbName group by 重复字段 order by count(*) desc )b
where a.重复字段=b.重复
select top 1 重复字段, count(*) as 重复次数
from tb group by 重复字段 order by count(*) desc
select top 1 重复字段 from tb group by 重复字段 order by count(*) desc