|< < 6 > >|

Unknown values and NULL

Comparison operators

Any comparison with NULL yields NULL

E.g., what is NULL < 5?

• NULL means "unknown".

• What is NULL < (unknown value)?

• Obviously, unknown.

• So NULL < 5 → NULL.

|< < 6 > >|