列出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认证