Extra Education
← All MySQL MCQs questions
1

What is the significance of the statement "GROUP BY d.name" in the following MySQL statement? SELECT d.name, COUNT (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name

Correct Answer: Aggregation of the field "name" of table "department"

Make the most of this question

This page focuses on one MySQL MCQs question from Programming. After checking the answer, return to the topic list to practice more or run a timed set.

← More MySQL MCQs MCQsAll Programming topicsMock test hub
MySQL MCQs MCQ: What is the significance of the statement "GROUP BY d.name" in the following MySQL statement? SELECT d.name, COUNT (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name | Extra Education