All Products
Search
Document Center

NULL conditions

Last Updated: Jun 18, 2021

A NULL condition tests null values. This is the only condition that is used to test for null values.

Syntax

expr IS [ NOT ] NULL

Examples

Execute the following statement:

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