1. StackOverflow 文档
  2. MySQL 教程
  3. GROUP BY
  4. GROUP BY 使用 COUNT 函数

GROUP BY 使用 COUNT 函数

Created: November-22, 2018 

SELECT department, COUNT(*) AS "Man_Power"
FROM employees
GROUP BY department;