🎴 Flashcard Mode

DBMS (SQL)

Card1 / 15
Mastered0
Review0
QuestionClick to flip

Select a query to display the number of employees who can earn commission in department number 30.

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

AnswerClick to flip back
A
select count(ENAME) from EMP where DEPTNO=30 and COMM is not NULL;
💡 Explanation:

It will fetch the correct data.

Change Mode