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

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

Table: Member

Empld	Name	Pay	Divno
1001	Shankhya	34000	10
1003	Ridhima	32000	50
1002	Sunish	45000	20

Table: Division

Divno	Divname	Location
10	Media	TF02
20	Dance	FF02
30	Production	SF01

Answer :-

Select  Divno from Division where ( select Divno from member ) <> Divno ;