Which of the following finds all orders placed before April 5, 2009 that havent yet shipped? a.
Question:
Which of the following finds all orders placed before April 5, 2009 that haven’t yet shipped?
a. SELECT * FROM orders WHERE orderdate < '04-05-09' AND shipdate = NULL;
b. SELECT * FROM orders WHERE orderdate < '05-04-09' AND shipdate IS NULL;
c. SELECT * FROM orders WHERE orderdate < 'APR-05-09' AND shipdate IS NULL;
d. SELECT * FROM orders WHERE orderdate < '05-APR-09' AND shipdate IS NULL;
e. None of the above
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Question Posted: