NCRE题库

登录注册
首页题库练习题目详情
数据库原理与应用单选题中等

下列哪个SQL语句能正确统计每个部门的员工数量？

ASELECT dept_id, COUNT(*) FROM employees GROUP BY dept_id
BSELECT dept_id, COUNT(dept_id) FROM employees GROUP BY dept_id
CSELECT dept_id, COUNT(emp_id) FROM employees ORDER BY dept_id
DALL上述选项都正确
上一题下一题