engineering computer science MCQ #738

Which SQL query retrieves the number of employees in each department?

engineering computer science MCQ #738

  1. Question 1

    Q1. Which SQL query retrieves the number of employees in each department?

    • A) SELECT department, COUNT(*) FROM employees GROUP BY department
    • B) SELECT department FROM employees
    • C) SELECT COUNT(*) FROM employees
    • D) SELECT department, SUM(*) FROM employees GROUP BY department

    Answer: SELECT department, COUNT(*) FROM employees GROUP BY department

    Explanation: The SQL query 'SELECT department, COUNT(*) FROM employees GROUP BY department' retrieves the number of employees in each department, using the COUNT aggregate function and GROUP BY clause.