GROUP BY using HAVING
suggest changeSELECT department, COUNT(*) AS "Man_Power"
FROM employees
GROUP BY department
HAVING COUNT(*) >= 10;
Using GROUP BY ... HAVING
to filter aggregate records is analogous to using SELECT ... WHERE
to filter individual records.
You could also say HAVING Man_Power >= 10
since HAVING
understands “aliases”.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents