Null conditions

A null condition is a condition that is used to detect NULL values. It is the only condition that can be used to detect NULL values.

Null condition syntax

The syntax of a null condition is as follows:

expr IS [ NOT ] NULL

For more information about NULL values, see NULL values.

Examples

SELECT last_name FROM emp WHERE comm_pct IS NULL ORDER BY last_name;