IS NULL and IS NOT NULL in SQL

IS NULL and IS NOT NULL in SQL — a practical guide to SQL IS NULL with clear examples you can reuse in real projects.

SQL Tutorial Series (32/100). Prefer one article? Read the complete SQL tutorial.

Short description

NULL means unknown — comparisons with =/<> do not work as beginners expect.

Null checks

SELECT * FROM users
WHERE deleted_at IS NULL;