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  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: