Given the Friends table:
ID   | NAME      | AGE
-------------------------
01   | Frank     | 18
02   | Sharon    | NULL
03   | John      | 20
04   | Jennifer  | NULL
How many records will the following query delete:
DELETE FROM Friends WHERE AGE = NULL;
Explanation
It is not possible to test for NULL values with comparison operators, such as =, <, or <>.
IS NULL and IS NOT NULL operators are used instead.

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback