单项选择题

统计每个部门中人数()

A.SELECT SUM(ID)FROM EMP GROUP BY DEPTNO;
B.SELECT SUM(ID)FROM EMP ORDER BY DEPTNO;
C.SELECT COUNT(ID)FROM EMP ORDER BY DEPTNO;
D.SELECT COUNT(ID)FROM EMP GROUP BY DEPTNO;

相关考题