Q
Which condition correctly tests for a NULL value?
-
A
WHERE commission = NULL
-
B
WHERE commission == NULL
-
C
WHERE commission IS NULL
-
D
WHERE commission EQUALS NULL
Correct Answer:
C. WHERE commission IS NULL
Explanation:
NULL is unknown, so comparisons with = never return true. Use IS NULL or IS NOT NULL.
