Multiple choice

Select a query to display the number of people in each job.

Consider the following relation schema ..... EMP(ENAME,EMPNO,SAL,COMM,DEPTNO,JOB,MGR,HIREDATE)...

  1. select count(ENAME), JOB from EMP group by JOB;

  2. select count(ENAME), JOB from EMP group by DEPTNO;

  3. select count(ENAME), JOB from EMP group by JOB;

  4. select counter(ENAME), JOB from EMP group by MGR;

  5. none of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

It will fetch the correct answer.

Keep practicing — related questions