Consider the following relation instance
num1 num2 100 100 100 NULL NULL 100 NULL NULL
SELECT * FROM myTable WHERE num1 != NULL;
SELECT * FROM myTable WHERE num1 = NULL;
I know that NULL values are looked up using
IS NULL and
IS NOT NULL.
But I want to know how are the above two queries evaluated. What is the number of tuples outputted by Q1 and Q2 by the ANSI standards?