mysql - 计算出现次数最多的字符串

Question

例如，我有一张 table :

Names  Details
--------------
wilson admin
david  member
wilson admin
wilson admin
sam    member
david  member

现在我想要实现的是显示这样的表格

Names  Details count
--------------------
wilson admin   3
david  member  2    
sam    member  1

我想根据名字出现的次数来显示

Answer 1

SELECT Name, Detail, COUNT(*) as Count
FROM MyTable
GROUP BY Name, Detail
ORDER BY Count DESC;

由于输出表 SELECT 中有不止一列，因此应按两列进行分组。