统计每个部门中人数( )
16 查阅
统计每个部门中人数( )
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;
参考答案: