mysql - 如何使用mysql找到最大计数？

Question

请告诉我下面的命令有什么问题

mysql> select max(count(*)) from emp1 group by name;
ERROR 1111 (HY000): Invalid use of group function

Answer 1

尝试:

SELECT NAME, 
       COUNT(*) as c 
FROM table 
GROUP BY name 
ORDER BY c DESC LIMIT 1