Database SQL Language Reference
ContentsOpens a new window
Opens a new window
Page 65 of 554

Null Conditions

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

null_condition::=

Description of null_condition.gif follows
Description of the illustration null_condition.gifOpens a new window

Table 6-9Opens a new window lists the null conditions.

Table 6-9 Null Condition

Type of Condition Operation Example 
IS [NOT] NULL

Tests for nulls.

See Also: "Nulls"Opens a new window

 
SELECT last_name
  FROM employees
  WHERE commission_pct
  IS NULL
  ORDER BY last_name;