單項選擇題

統(tǒng)計每個部門中人數(shù)()

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;

微信掃碼免費搜題