CBSE Class 12 Informatics Practices Question 88 of 91

JOINS and SET Operations — Question 24

Back to all questions
24
Question

Question 24

Write a SQL query to display all the divnos in Division table but not in the Member table.

Table : Member

EmpIdNamePayDivno
1001Shankhya3400010
1003Ridhima3200050
1002Sunish4500020

Table : Division

DivnoDivnameLocation
10MediaTF02
20DanceFF02
30ProductionSF01
Answer
SELECT D.Divno
FROM Division D
LEFT JOIN Member M ON D.Divno = M.Divno
WHERE M.Divno IS NULL;
Output
+-------+
| Divno |
+-------+
|    30 |
+-------+