Question: Which of the following finds all orders placed before April 5, 2009 that havent yet shipped? a. SELECT * FROM orders WHERE orderdate < '04-05-09'

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

Step by Step Solution

3.58 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

d SELECT FROM ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12126ec5_716417.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12126ec5_716417.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!