Write an SQL query to retrieve the number of employees in each department.

Last Updated :
Discuss
Comments

Write an SQL query to retrieve the number of employees in each department.

SELECT COUNT() FROM employees ORDER BY department;

SELECT COUNT(department) FROM employees GROUP BY department;

SELECT COUNT(*) FROM employees GROUP BY department;

SELECT COUNT(*) AS employees_count, department FROM employees;

This question is part of this quiz :

SQL Query-Based Questions Quiz
Tags:
SQL
SQL Quiz
Databases
Share your thoughts in the comments
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy