从 GROUP BY 操作中选择最大计数 [英] Selecting the maximum count from a GROUP BY operation

问题描述

原谅我的 SQL 知识，但我有一个 Person 表，其中包含以下数据 -

Forgive my SQL knowledge, but I have a Person table with following data -

Id          Name
----        ------
1           a
2           b
3           b
4           c

我想要以下结果 -

Name      Total
------    ------
b         2

如果我使用 GROUP BY 查询 -

If I use the GROUP BY query -

SELECT Name, Total=COUNT(*) FROM Person GROUP BY Name  

它给了我 -

Name   Total
------ ------
a      1
b      2
c      1

但我只想要最大计数的那个.我怎么得到它?

But I want only the one with maximum count. How do I get that?

推荐答案

如果你想要领带

SELECT top (1) with ties Name, COUNT(*) AS [count]
  FROM Person 
 GROUP BY Name  
 ORDER BY count(*) DESC

这篇关于从 GROUP BY 操作中选择最大计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！