列出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
答案解析:有

微信扫一扫手机做题
列出EMP表中,从事每个工种(JOB)的员工人数()
微信扫一扫手机做题