Returns the count of non-NULL rows.
Syntax
COUNT(expr)Example
Enter values below to update the example in real time.
department_id→headcount→employees→-- 부서별 직원 수
SELECT department_id, COUNT(*) AS headcount
FROM employees
GROUP BY department_id;