3个回答
展开全部
select top 1 某列,count(*) from 表 group by 某列 order by count(*) desc
展开全部
select column,max(count(*)) from
(select column,count(*) from table
group by column) test;
(select column,count(*) from table
group by column) test;
展开全部
SELECT 某列, COUNT(*)
FROM 某表
GROUP BY 某列
ORDER BY COUNT(*)
FROM 某表
GROUP BY 某列
ORDER BY COUNT(*)
本回答被提问者采纳
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询