Multiple choice

Select a query to display the number of employees in department number 30.

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

  1. select count(ENAME) from EMP where DEPTNO=30;

  2. select count(EMPNO) from EMP where DEPTNO=30;

  3. select count(SAL) from EMP where DEPTNO=30;

  4. options 1 and 2

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

Both the option 1 and 2 will fetch the correct data.

Keep practicing — related questions