单选题列出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)的员工人数()
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;