IS NULL vs = NULL

IS NULL vs = NULL

In SQL, NULL represents a missing or undefined value. You cannot use = NULL.

Incorrect:

SELECT * FROM employees WHERE commission_pct = NULL; -- This returns no rows

Correct:

SELECT * FROM employees WHERE commission_pct IS NULL;

Use IS NOT NULL to check for non-null values.