A SQL query must retain rows whose CancellationDate is missing. Which predicate is appropriate?

Published
  1. CancellationDate = '' for a date column
  2. CancellationDate <> NULL
  3. CancellationDate IS NULL
  4. CancellationDate = NULL

Comments — 0