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.

Слідкуй за CodeGalaxy

Мобільний додаток Beta

Get it on Google Play
Зворотній Зв’язок
Cosmo
Зареєструйся Зараз
або Підпишись на майбутні тести