列出EMP表中，从事每个工种（JOB）的员工人数（）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;

单项选择题

列出EMP表中，从事每个工种（JOB）的员工人数（）

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;

Oracle认证综合练习