Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?
A) SELECT * FROM orders WHERE shipdate = NULL;
B) SELECT * FROM orders WHERE shipdate NULL;
C) SELECT * FROM orders WHERE shipdate LIKE 'NULL';
D) none of the above

Question

Contents of the ORDERS table
 
-Based upon the contents of the ORDERS table in the accompanying figure,which of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?​
A) ​SELECT * FROM orders WHERE shipdate = NULL; 
B) ​SELECT * FROM orders WHERE shipdate > NULL; 
C) ​SELECT * FROM orders WHERE shipdate LIKE 'NULL'; 
D) ​none of the above

Quizplus · Accepted Answer

In SQL, to check for NULL values, the `IS NULL` condition must be used. None of the provided options correctly use this condition. Options A, B, and C use incorrect syntax for checking NULL values.

Contents of the ORDERS Table