NCRE题库

登录注册
首页题库练习题目详情
技能操作部分单选题中等

以下SQL语句中，哪一项可以统计每个部门的员工数量？

ASELECT COUNT(*) FROM employees
BSELECT dept_id, COUNT(*) FROM employees GROUP BY dept_id
CSELECT dept_id, COUNT(dept_id) FROM employees GROUP BY dept_id
DSELECT dept_id, SUM(*) FROM employees GROUP BY dept_id
上一题下一题