Essential Books

GROUP BY USING COUNT Function

suggest change 
SELECT department, COUNT(*) AS "Man_Power"
FROM employees
GROUP BY department;
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Group By:
* Group By
* GROUP BY using HAVING
* Group By using Group Concat
* Group By Using MIN function
* GROUP BY with AGGREGATE functions
* GROUP BY USING SUM Function
* GROUP BY USING COUNT Function
Table Of Contents