为什么这里max了count的统计后的结果与count的结果一样？

Question

select max(c) from (select count(t_employee.department_id) as c from t_employee group by t_employee.department_id) as count group by c
为什么这里max了count的统计后的结果与count的结果一样？

Answer 1

你这个返回的就是count最大的值。