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;