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
d SELECT FROM ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c12126ec5_716417.pdf
180 KBs PDF File
1803_60b8c12126ec5_716417.docx
120 KBs Word File
