|< < 7 > >|

Unknown values and NULL

Comparison operators

Remember: The where clause keep rows for which the predicate evaluates to true.

So the where clause discards rows for which the predicate evaluates to false or null.

Example:

T	select X from T where Y > 10
X Y 1 10 2 null 3 30 4 null	X 3

|< < 7 > >|