河南成教 / 河南理工大学
正确率:100%
9、
统计每个部门中人数( )
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;
统计每个部门中人数( )
参考答案: