多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

列出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
答案解析:
进入题库查看解析

微信扫一扫手机做题