SQL · Reading data

is null

Tests for the absence of a value. NULL never equals anything, including itself.

sqlRunnable example sql course

Syntax

where column is null

Example

Open in the lab

WITH lessons(note) AS (VALUES (NULL), ('ready'))
SELECT note FROM lessons WHERE note IS NULL;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.