單項(xiàng)選擇題

列出EMP表中，從事每個(gè)工種（JOB）的員工人數(shù)（）

A.select job from emp;
B.select job,count(*) from emp;
C.select distinct job,count(*) from emp;
D.select job,count(*) from emp group by job;
E.select job,sum(empno) from emp group by job;

微信掃碼免費(fèi)搜題