Snippet

Checking for Missing Data Using IS NULL

Because NULL represents unknown or missing data, equality operators like = cannot compare NULL values; SQL requires using IS NULL instead.

snippet.sql

sql

SELECT product_name, price
FROM products
WHERE category_id IS NULL;

Breakdown

SELECT product_name, price

Chooses product_name and price columns for the output display.

FROM products

Designates products as the target database table.

WHERE category_id IS NULL;

Filters rows to only include products without an assigned category.