请告诉我下面的命令有什么问题
mysql> select max(count(*)) from emp1 group by name;
ERROR 1111 (HY000): Invalid use of group function
最佳答案
尝试:SELECT NAME, COUNT(*) as c FROM table GROUP BY name ORDER BY c DESC LIMIT 1
关于mysql - 如何使用mysql查找最大计数?,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/16441032/