移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

列出EMP表中,从事每个工种(JOB)的员工人数()

发布日期:2022-06-13

列出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;

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!