Skip to content
Worked Examples · Example 8.11

Q.The following query displays details of all those employees who have not been given a bonus. This implies that the bonus column will be blank.

CBSENCERTSubjective· 2mImportance★★★★★
44% · 20/45 Questions
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

Employees with no bonus recorded.

SELECT * FROM EMPLOYEE WHERE Bonus IS NULL;

Output:

+-------+----------+--------+-------+--------+
| EmpNo | Ename    | Salary | Bonus | DeptId |
+-------+----------+--------+-------+--------+
|   107 | Vergese  |  15000 |  NULL | D01    |
|   108 | Nachaobi |  29000 |  NULL | D05    | …

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.