试题详情
单项选择题列出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;

  • D

  • 关注下方微信公众号，在线模考后查看

热门试题