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
Keep exploring
SQL quizzes
Cosmo
Sign Up Now
or Subscribe for future quizzes