NULL Handling in WHERE
Suppose R(A, B) has a tuple t: (A = 2, B = NULL). Does the following query output t?
SELECT *
FROM R
WHERE ((A IS NULL) OR (B = 2)) AND (B IS NULL)Sign in to answer questions and track your progress
Sign InSuppose R(A, B) has a tuple t: (A = 2, B = NULL). Does the following query output t?
SELECT *
FROM R
WHERE ((A IS NULL) OR (B = 2)) AND (B IS NULL)Sign in to answer questions and track your progress
Sign In