Filter rows with missing values.
Section: Filtering Rows
Test for NULL
sql
sql
SELECT *
FROM tasks
WHERE completed_at IS NULL;Explanation
Use IS NULL or IS NOT NULL, not = NULL.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Filtering Rows