Evaluate the following SQL statement:
Which statement is true regarding the above query if one of the values generated by the
subquery is null?
A.
It produces an error.
B.
It executes but returns no rows.
C.
It generates output for null as well as the other values produced by the subquery.
D.
It ignores the null value and generates output for the other values produced by the
subquery.
C is incorrect, the answer should be D.
If the criteria is comparing NULL with NULL then result is NULL, which will not return any row containing null value.
D is correct. Null Null, ever! Null is equal to “unknown” and unknown does not equal unknown.
Yes D is correct
ANSWER IS D.