IntermediateWHERE & Filtering
Find products with NULL cost (cost unknown)
The query
SQL
SELECT product_id, name, price
FROM products
WHERE cost IS NULL;Note
“NULL means "unknown" or "not applicable". Always use IS NULL, never = NULL.
SELECT product_id, name, price
FROM products
WHERE cost IS NULL;Note
“NULL means "unknown" or "not applicable". Always use IS NULL, never = NULL.