NULL in AND, OR, NOT logic in SQL - Step-by-Step Execution

Concept Flow - NULL in AND, OR, NOT logic

Start with two boolean values

↓

Apply AND operation

↓

Check if any operand is NULL

↓

Result may be NULL

↓

Apply OR operation

↓

Check if any operand is NULL

↓

Result may be NULL

↓

Apply NOT operation

↓

If operand is NULL, result is NULL

↓

End

This flow shows how SQL evaluates AND, OR, and NOT when NULL values are involved, resulting in TRUE, FALSE, or NULL outcomes.

Execution Sample

SQL

SELECT TRUE AND NULL AS and_result,
       FALSE OR NULL AS or_result,
       NOT NULL AS not_result;

This query shows how SQL returns results when NULL is used with AND, OR, and NOT operators.

Execution Table

Step	Expression	Operands	Evaluation	Result
1	TRUE AND NULL	TRUE, NULL	TRUE AND unknown	NULL
2	FALSE OR NULL	FALSE, NULL	FALSE OR unknown	NULL
3	NOT NULL	NULL	NOT unknown	NULL
4	TRUE AND FALSE	TRUE, FALSE	TRUE AND FALSE	FALSE
5	FALSE OR TRUE	FALSE, TRUE	FALSE OR TRUE	TRUE
6	NOT TRUE	TRUE	NOT TRUE	FALSE
7	NOT FALSE	FALSE	NOT FALSE	TRUE
8	TRUE AND TRUE	TRUE, TRUE	TRUE AND TRUE	TRUE
9	FALSE OR FALSE	FALSE, FALSE	FALSE OR FALSE	FALSE
10	End			Execution complete

💡 All logical operations evaluated; NULL propagates as unknown in AND, OR, NOT.

Variable Tracker

Expression	Initial	After Evaluation	Final
and_result	TRUE AND NULL	Evaluated as TRUE AND unknown	NULL
or_result	FALSE OR NULL	Evaluated as FALSE OR unknown	NULL
not_result	NOT NULL	Evaluated as NOT unknown	NULL

Key Moments - 3 Insights

Why does TRUE AND NULL result in NULL instead of TRUE or FALSE?

Because NULL means unknown, TRUE AND unknown is unknown, so the result is NULL as shown in execution_table row 1.

Why does FALSE OR NULL result in NULL and not FALSE?

Since NULL is unknown, FALSE OR unknown is unknown, so the result is NULL, as seen in execution_table row 2.

What happens when NOT is applied to NULL?

NOT NULL is also unknown, so the result is NULL, demonstrated in execution_table row 3.

Visual Quiz - 3 Questions

Look at the execution_table, what is the result of TRUE AND NULL at step 1?

A TRUE

B NULL

C FALSE

D Error

💡 Hint

Check the 'Result' column in execution_table row 1.

At which step does FALSE OR NULL evaluate to NULL?

A Step 9

B Step 5

C Step 2

D Step 4

💡 Hint

Look at the 'Expression' and 'Result' columns in execution_table.

If NOT NULL was changed to NOT TRUE, what would be the result according to the table?

A FALSE

B TRUE

C NULL

D Error

💡 Hint

See execution_table row 6 for NOT TRUE evaluation.

Concept Snapshot

SQL NULL in logic:
- TRUE AND NULL = NULL (unknown)
- FALSE OR NULL = NULL (unknown)
- NOT NULL = NULL (unknown)
- NULL means unknown, propagates in AND, OR, NOT
- Results can be TRUE, FALSE, or NULL
- NULL is not TRUE or FALSE, but unknown

Full Transcript

This visual execution shows how SQL handles NULL in logical operations AND, OR, and NOT. When NULL is involved, the result often becomes NULL, meaning unknown. For example, TRUE AND NULL results in NULL because the second operand is unknown. Similarly, FALSE OR NULL results in NULL. Applying NOT to NULL also results in NULL. The execution table traces these evaluations step-by-step, showing how SQL treats NULL as unknown in logic. This helps understand why logical expressions with NULL do not simply return TRUE or FALSE but can return NULL to represent uncertainty.