Null Conditions

A NULL condition tests for nulls. This is the only condition that you should use to test for nulls.

null_conditions::=

Table 7-10 lists the null conditions.

IS [NOT] NULL 

SELECT last_name
  FROM employees
  WHERE commission_pct
  IS NULL;