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
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.