How will you fetch the values from TableA that are not present in Tabl

How will you fetch the values from TableA that are not present in TableB without using the NOT keyword?

Answer»

TABLEB
20
45

The result should have 21 and 25.

We can do it EASILY by USING the SELECT and EXCEPT keywords as SHOWN below:

SELECT * FROM TableA EXCEPT SELECT * FROM TableB;